Forum Discussion

Pandetbaby's avatar
Pandetbaby
Frequent Visitor
5 years ago

Getting the difference of a value between two seperate time slicers.

Hey Everyone, 

 

I'm trying to figure out a measure to give me what the difference between two time slicers are. 

We're trying to find out how many events has happened in the current date, the previous date and get a measure to determine what the movement between has been. 

 

I've seperated the Dates into two sheets form the samesource, one will be my "Comparison Month" and the other "Current Month"

 

The formulas are as follows, and both of them give me the correct answer. 

Comparison Month= calculate([Count Total Instances],filter('Workforce','Workforce'[Start Date ]= max('Start Date Comparison'[Start Date ])))
 
Current Month = calculate([Count Total Instances],FILTER('Workforce','Workforce '[Start Date ]=max('Workforce'[Start Date (bins)])))
 
Problem occurs when I want to make the measure to subtract Current from the Comparison. I use the formua
Movement = [Current Month] - {Comparison Month] 
However, for some reason it appears that the comparison is = 0, as this formula just returns to Current Month
 
E.g.
Current Month= 10
Comparison Month = 8
Movement=10 (when it should be 2)
 
Thank you!
change
Compare
time functions

2 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Pandetbaby 

    Have you checked that both measures [Current Month] and [Comparison Month] return the correct result if you use them exactly in the scenario where you want to use [Movement] ? If so, [Movement] should certainly work. You show 

    Movement = [Current Month] - {Comparison Month]

    instead of the correct

    Movement = [Current Month] - [Comparison Month]

    but I'm guessing that's just a typo

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers