Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am using running total to calculate dollar values over the course of two years. The problem is there are some dollar values prior to two years and not reflecting in the final value. I want to use dates for only two years but want to get the dollar values in the rolling total that are before two years. I am stuck up pretty bad, any help will be much appriciated. So far I have tried this, but still not able to proceed.
Hi @Anonymous ,
Since I'm not certain about the structure of your dataset, I have created a table like this a meaure to try to meet your requirement:
RunningTotal =
FORMAT (
CALCULATE (
SUM ( 'Table'[value] ),
DATESINPERIOD ( 'Table'[Date], LASTDATE ( 'Table'[Date] ), -3, YEAR )
),
"$#,##0"
)
The result is like this:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Not sure I follow.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |