Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Values from Previous month not showing

I've created a table as following. MRRWaterFall = CALCULATETABLE( SUMMARIZE('Calendar','Calendar'[BeginningOfMonth],"Beginning MRR",[Beginning MRR],"New MRR",[New MRR],"Expansion MRR",[Expansio...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I managed to solve this by creating a new column instead of using measures.

     

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

Your dates in PREVIOUSMONTH should be from your date table that is related to your dates in the MRR_OPS table. Date Intelligence requires a true date table to reliably work.

 

I think there is some additional context transition going on too as when you use one measure in another, DAX wraps that measure reference in CALCULATE(), but I'd need to see your PBIX file to really dig into that.