Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a measure in which I would to find the quantity for the latest week.
Wanted to do it like this but placeholder error:
My MaxWeek :
But now I want the Qty belonging to MaxWeek and Maxweek -1
Because I want to see the change between the last week and the week before.
What am I doing wrong? Or is there a better way?
Solved! Go to Solution.
Try
BO Current =
VAR MaxWeek = [Max week]
RETURN
CALCULATE ( [BO Tot Qty], 'Dim date'[Week nr (ISO)] = MaxWeek )
If your data spans multiple years you may also want to filter on the year.
Try
BO Current =
VAR MaxWeek = [Max week]
RETURN
CALCULATE ( [BO Tot Qty], 'Dim date'[Week nr (ISO)] = MaxWeek )
If your data spans multiple years you may also want to filter on the year.
Superb! @johnt75
Works like a charm 😄 (also indeed put in a year filter)
So guess you cannot directly reference the measure but putting it in a variable solves this 🙂