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.
I need to create a visualization that compares sales data from week "x" and week "x-1", that is, the week immediately before.
Something like this:
First, I created a filter per week. then, I was thinking of using cards, in the first card, add the sales of the week "x", in the second card, I should show the sales of the week "x-1". I used the following measure:
Sale_sem_bef = CALCULATE(SUM(Sales[COP Value]);FILTER(Calendar;Calendar[Profit_Week]=[filter_sem_bef])).
filter_sem_bef = SELECTEDVALUE(Calendar[Profit_Week];1)-1
However, the measurement (Sale_sem_bef) is blank.
I believe that the week's initial filter is affecting the measurement.
How can I solve it? Is there another way to get what I need?
Thaks
Solved! Go to Solution.
Hi @Cathe208 ,
Total Rollover = VAR maxDate = MAX (m1[Real Date]) VAR Rollover = CALCULATE ( [Sum Excess], m1[Real Date] <= maxDate ) RETURN Rollover
You will need to do something along these lines to get a previous date or week. In this case, maxDate is set to a the current date, and you filter the table if you use < to the row before this date. I will provide my pbix and hopefully you can tease out the pattern. Unfortunately I am working on something right now. Rollover or go to https://community.powerbi.com/t5/Community-Blog/Using-EARLIER-with-a-SMART-INDEX/ba-p/809341 and scroll down to the comment by MarcoRusso. Or finally google dax Previous Row. You are looking for a pattern. Good Luck! Nathaniel
Proud to be a Super User!
Hi @Cathe208 ,
Total Rollover = VAR maxDate = MAX (m1[Real Date]) VAR Rollover = CALCULATE ( [Sum Excess], m1[Real Date] <= maxDate ) RETURN Rollover
You will need to do something along these lines to get a previous date or week. In this case, maxDate is set to a the current date, and you filter the table if you use < to the row before this date. I will provide my pbix and hopefully you can tease out the pattern. Unfortunately I am working on something right now. Rollover or go to https://community.powerbi.com/t5/Community-Blog/Using-EARLIER-with-a-SMART-INDEX/ba-p/809341 and scroll down to the comment by MarcoRusso. Or finally google dax Previous Row. You are looking for a pattern. Good Luck! Nathaniel
Proud to be a Super User!
Nathaniel_C Thanks very much for your solution. It worked.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
29 | |
27 | |
24 | |
22 |