Forum Discussion

Veblengood's avatar
Veblengood
Icon for Helper I rankHelper I
4 years ago
Solved

Measure not showing as cumulative graph

I have a dataframe with transactional data which has a weekly granuality, this df is connected to date masterdata. I attempting to compare this years revenue with last years revenue in a cumulative g...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Veblengood , try a measure like

     

    CALCULATE([Retail revenue], FILTER(ALL(Dates[ISO Weeknumber]),Dates[ISO Weeknumber] <= maxweeknr && Dates[ISO Year] = maxyearnr-1))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Veblengood , try a measure like

 

CALCULATE([Retail revenue], FILTER(ALL(Dates[ISO Weeknumber]),Dates[ISO Weeknumber] <= maxweeknr && Dates[ISO Year] = maxyearnr-1))