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 all,
Looking for some help please 😊 I am trying to figure out week over week percent change by Supplier or department in separate tables not a graph as I was able to get that with a dates table (i.e Supplier 1, Supplier 2 – % change from previous week).
What I am encountering is totals in the table returning the same values. Would any one be able to help me with this please.
I was able to display this in a chart using the below dax (Screen shot highlighted below), but want to see it in a table or matrix table.
Measure =
VAR lastWeekAmount =
CALCULATE (
SUM ( Append1[Video Views] ),
FILTER (
ALL ( 'Calendar' ),
'Calendar'[WeekNum]
= MIN ( 'Calendar'[WeekNum] ) - 1
)
)
RETURN
DIVIDE (SUM (Append1[Video Views] ) - lastWeekAmount, lastWeekAmount, 0 )
@Vari209 , Can you highlight what is wrong. The formula can be run on week rank
Have these new columns in Date Table, Week Rank is Important in Date/Week Table
Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format
These measures can help
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Hi Amitchandak,
Thank you so much for the quick response! 🙂 I would like to show the percent change from the previous week for a specific groupling - for example the screen shot below in excel is showing Facebook current week amount total for 91-180 days is $4M and the % change from the previous week is -4%. How would I show this exact example in a table or matrix in PowerBi. I was able to show this is in a graph, but only by selecting on a departmentr filter for each one rather than have the totals and percenategs all in one table.
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 |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |