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 = CALCULATE(sum('BI - Discounts Balance'[Balance]),DATEADD('BI - Discounts Balance'[TransactionDate], 60, DAY))
Thank you !
Go to Solution.
Try this MEASURE
Rolling balance =
SUM ( TableName[Amount] ),
DATESINPERIOD ( TableName[Date], SELECTEDVALUE ( TableName[Date] ), -60, DAY )
View solution in original post
You can't do this kind of calculation as a column - add the calculation as a measure instead.
Have you tried creating a measure instead to see if it works? If you still have any question on this issue, feel free to post here.
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
Thank you, this has worked!
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!