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.
hi all, probably this is super easy, but i struggle with it, i need to present on below matrix table difference week over week just for the last two periods (in below between 20 and 27 march), so it basically should show me -22 etc. i did it in excel but we moved to power bi. this is a count of lines. i also have the same with sum of import.
could you please help me how to do it? i tried with calculate and max or with dates in period. but it shows me strange results.
hi @martaTr ,
if you have a weeknum column in your dataset, that maybe used. ( for more context: How to Calculate Week over Week Change in Power BI (youtube.com)
OR,
you could explore if the (52) Calculate Growth From Previous Non Consecutive Date - YouTube may be a better fit.
Another alternative maybe to explore DATEADD function (DAX) - DAX | Microsoft Learn
Kindly provide a sample input table masking sensitive data if this doesn't work for you.
thank you, it seems like it's working, however i am wondering how can i this new metric WoW add to the table.
Here is my formula:
Measure3 =
VAR LastDate1 =
MAXX ( ALLSELECTED ( Affinity[As of Date] ), Affinity[As of Date] )
VAR LastSales =
CALCULATE (
COUNT ( [Importo] ),
FILTER ( ALL ( Affinity[As of Date] ), Affinity[As of Date] = LastDate1 )
)
VAR PrevDate =
MAXX (
FILTER ( ALL ( Affinity[As of Date] ), 'Affinity'[As of Date] < LastDate1 ),
Affinity[As of Date]
)
VAR PrevSales =
CALCULATE (
COUNT ( [Importo] ),
FILTER ( ALL ( Affinity[As of Date] ), Affinity[As of Date] = PrevDate )
)
RETURN
IF ( ISBLANK ( PrevDate ), BLANK (), LastSales - PrevSales )
Unfortunately it doesnt work when i normally add it to columns/ rows/values.Now it's in seprate table hidden under a main one which doesnt look good and it 's completely impractical. Any ideas how to present that metric? maybe other chart?
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 |