Display value from today & last month from a query

[tina345]

Hello Experts,

I have data set like this.

I am trying to come up with 2 cards with side by side comparision of value (today vs last day of last month).Do we need to create 2 different measures ?Could you please help on how to achieve this?

Date, Value
-------------
6/1/2021,100
6/2/2021,200
6/30/2021,300 -- Last Month Value
7/1/2021,400
7/14/2021,500 -- Today's Value

Expected Result as of 7/14/2021

-------------------------------------

300 , 500

[v-yangliu-msft · Accepted solution]

Hi  @tina345 ,

Here are the steps you can follow：

1. Create measure.

lastdate =
CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Date]=EOMONTH(TODAY(),-1)))

Today = CALCULATE(SUM('Table'[Value]),'Table'[Date]=TODAY())

IF =
IF([lastdate]>[Today],"True","Flase")

2. Place it in the Mutli -row card

3. Result:

Three measures will be placed in a Card to display all the results

Best Regards,

Liu Yang

[tina345]

I got it, we can use multiple conditions.

There is some syntax issue.

Thaks a lot.

[amitchandak]

@tina345 ,Try two measures like

calculate(sum(Table[Value]), filter(Table, Table[Date] = today()))

calculate(sum(Table[Value]), filter(Table, Table[Date] = eomonth(today(),-1)))

[tina345]

Thanks Amitchandak,

   If I have to add one more filter, what is the easiest way to do that?

   There will be 2 filter, and looks like sum takes only 1 argument.

    I am getting too many arguments to the Sum function error message.