Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good Day,
I am trying to get a running total by year but am just getting the total of each year. What I am wanting is a running total by year. So for instance 2018 has 1085 as the count and 2019 has 12404 as the count on the matrix I would like 2019 to be a sum of 2018 & 2019 and to continue on for the rest of the years. Can someone help me through this madness?
Current Formula:
Many Thanks,
Your friendly neighborhood Lydia
Solved! Go to Solution.
@Anonymous Try Better Running Total: Better Running Total - Microsoft Power BI Community
Better RT =
VAR __Date = MAX('Assets'[Created_Date])
VAR __Table = FILTER(ALLSELECTED('Assets'),[Created_Date] <= __Date)
RETURN
SUMX(__Table,[Status Bit])
@Anonymous Try Better Running Total: Better Running Total - Microsoft Power BI Community
Better RT =
VAR __Date = MAX('Assets'[Created_Date])
VAR __Table = FILTER(ALLSELECTED('Assets'),[Created_Date] <= __Date)
RETURN
SUMX(__Table,[Status Bit])
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |