Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
I got it, we can use multiple conditions.
There is some syntax issue.
Thaks a lot.
@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)))
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.
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |