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

[Pandetbaby]

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!

[amitchandak]

@Pandetbaby , I have a blog on two date range comparison, see if somehow can help in this case

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[AlB]

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