Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
3 years ago
Solved

Placeholder 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. E...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    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.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

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.

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
3 years ago

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 🙂