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 )
)
Data4Beer's avatar
Data4Beer
Frequent Visitor
8 years ago

 

 

 

 

Hi There

 

Yes I have just tried it as a calculation. When I display the result as a table, the rolling 60 day balance just reflects the balance amount as shown in the screenshot below

 

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!