Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi im looking a dax tha only allows me to calculate running total for the most recent date available, (without displaying previouse date), I managed to get the running total but I need only to display the cummulative view in one row (which will chang every time that I changed the dates parameters)
Date | Dmd Total | **bleep** Dmd Total | Desirable outcome |
1/30/2023 0:00 | 0 | 0 | |
2/6/2023 0:00 | 0 | 0 | |
2/13/2023 0:00 | 777 | 777 | |
2/20/2023 0:00 | 687 | 1464 | |
2/27/2023 0:00 | 340 | 1804 | |
3/6/2023 0:00 | 0 | 1804 | |
3/13/2023 0:00 | 0 | 1804 | |
3/20/2023 0:00 | 0 | 1804 | 1804 |
Hi @jamc
please try
=
IF (
SELECTEDVALUE ( [Date] ) = MAXX ( ALLSELECTED ( [Date] ), [Date] ),
[Running Dmd Total]
)
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
13 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |