Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am able to calculat the running total based on max date. I would like to get final number from running total measure based on the max date. I have attached below example (i.e . Total value in table formate). I am looking for new Dax formuala to get this calucation
Cumulative (running total measure) =
Date | Product | Value | Cumulative | Totalvalue |
5/2/2024 0:00 | A | 100 | 100 | |
5/3/2024 0:00 | A | 50 | 150 | |
5/4/2024 0:00 | A | 30 | 180 | |
5/5/2024 0:00 | A | 26 | 206 | |
5/6/2024 0:00 | A | 30 | 236 | 236 |
2/28/2023 0:00 | B | 50 | 50 | |
3/1/2023 0:00 | B | 30 | 80 | |
3/2/2023 0:00 | B | 26 | 106 | |
5/6/2024 0:00 | B | 100 | 206 | 206 |
Solved! Go to Solution.
@Nagesh20 , Create a measure using your measure
if(Max(Calendar[Date]) = maxx(filter(allselected(Table), Table[Product] = max(Table[Product]) ), Table[Date]) , [Cumulative (running total measure) ], blank())
or
Measure =
var _max =maxx(filter(allselected(Table), Table[Product] = max(Table[Product]) ), Table[Date])
return
Switch ( true(),
Max(Calendar[Date]) = _max , [Cumulative (running total measure) ],
Max(Calendar[Date]) < _max , 0 ,
blank())
@Nagesh20 , Create a measure using your measure
if(Max(Calendar[Date]) = maxx(filter(allselected(Table), Table[Product] = max(Table[Product]) ), Table[Date]) , [Cumulative (running total measure) ], blank())
or
Measure =
var _max =maxx(filter(allselected(Table), Table[Product] = max(Table[Product]) ), Table[Date])
return
Switch ( true(),
Max(Calendar[Date]) = _max , [Cumulative (running total measure) ],
Max(Calendar[Date]) < _max , 0 ,
blank())
Hi @amitchandak
I am not able to get the total when applying the second formula that you suggested. Could you please advice how to get the total for this formula in the table.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |