Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Solved! Go to Solution.
HI @Data4Beer
Try this MEASURE
Rolling balance = CALCULATE ( SUM ( TableName[Amount] ), DATESINPERIOD ( TableName[Date], SELECTEDVALUE ( TableName[Date] ), -60, DAY ) )
Hi @Data4Beer,
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.
Regards
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
HI @Data4Beer
Try this MEASURE
Rolling balance = CALCULATE ( SUM ( TableName[Amount] ), DATESINPERIOD ( TableName[Date], SELECTEDVALUE ( TableName[Date] ), -60, DAY ) )
Thank you, this has worked!
You can't do this kind of calculation as a column - add the calculation as a measure instead.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |