Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure formula to get % value difference from different dates

Hey guys, need some help to make this work:

 

I'm creating a new measure to get the difference in value ($MM) based on two different dates.

 
The formula I'm using doesn't have any error but when I try to display it on a card visualization to see the % difference, it doesn't work. This is the formula so far:
 
  • Q/Q RESL = (CALCULATE(SUM(RESL_Table[$MM]),RESL_Table[Date]= "Jul-20")) - (CALCULATE(SUM(RESL_Table[$MM]),RESL_Table[Date]= "Jun-20"))

Any feedback? Thanks

Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , this will work if date is the month and there is no filter date

     

    Q/Q RESL = (CALCULATE(SUM(RESL_Table[$MM]),eomonth(RESL_Table[Date],0)=date(2020,7,31))) - (CALCULATE(SUM(RESL_Table[$MM]),eomonth(RESL_Table[Date],0)= date(2020,6,30)))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , this will work if date is the month and there is no filter date

     

    Q/Q RESL = (CALCULATE(SUM(RESL_Table[$MM]),eomonth(RESL_Table[Date],0)=date(2020,7,31))) - (CALCULATE(SUM(RESL_Table[$MM]),eomonth(RESL_Table[Date],0)= date(2020,6,30)))