Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
@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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
128 | |
29 | |
28 | |
24 | |
22 |