Forum Discussion

Data4Beer's avatar
Data4Beer
Frequent Visitor
8 years ago
Solved

Rolling 60 Day Balance

I am trying to do a 60 day rolling balance. Please review my screenshot below and help me see where I am going wrong. Nothing is populating in the highlighted column.     60 Day Balance = CALCULAT...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI Data4Beer

     

    Try this MEASURE

     

    Rolling balance =
CALCULATE (
    SUM ( TableName[Amount] ),
    DATESINPERIOD ( TableName[Date], SELECTEDVALUE ( TableName[Date] ), -60, DAY )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

HI Data4Beer

 

Try this MEASURE

 

Rolling balance =
CALCULATE (
    SUM ( TableName[Amount] ),
    DATESINPERIOD ( TableName[Date], SELECTEDVALUE ( TableName[Date] ), -60, DAY )
)
Data4Beer's avatar
Data4Beer
Frequent Visitor
8 years ago

Thank you, this has worked!