Forum Discussion
rpinxt
Solution Sage
Solution SagePlaceholder issue Calculate formula
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 :
MaxWeek = WEEKNUM(MAX('Backorder Details'[Doc. Entry]))
I also made MaxWeek -1
As you see it works:
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?
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.
2 Replies
johnt75Super User
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.
