Forum Discussion

Yunka's avatar
Yunka
Icon for Advocate I rankAdvocate I
9 years ago
Solved

DAX problem calculating Prior Fiscal YTD

Hi everyone, I'm trying to calculate a measure based on prior fiscal year to date numbers. My dates table has every calendar date, however the measure I'm using is aggregated by week ending date in ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Yunka,

     

    If Understanding is right you need the running total upto the week for the previous year.

     

    If so just a small tweak to your expression will do. Change the LYMetric as

    LY Metric:=CALCULATE([Production Revenue], FILTER(ALL(Dates), Dates[FiscalWeek] <= MAX(Dates[FiscalWeek]) && Dates[FiscalYear]  = MAX(Dates[FiscalYear]) - 1))

     

    Change is highlighted in bold colour.

     

    Cheers

     

    CheenuSing

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Yunka,

 

If Understanding is right you need the running total upto the week for the previous year.

 

If so just a small tweak to your expression will do. Change the LYMetric as

LY Metric:=CALCULATE([Production Revenue], FILTER(ALL(Dates), Dates[FiscalWeek] <= MAX(Dates[FiscalWeek]) && Dates[FiscalYear]  = MAX(Dates[FiscalYear]) - 1))

 

Change is highlighted in bold colour.

 

Cheers

 

CheenuSing

Yunka's avatar
Yunka
Icon for Advocate I rankAdvocate I
9 years ago

Thank you Anonymous, that works!