Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @Anonymous ,
Try this measure:
This is the correct code:
// Assumption:
// [Index] column establishes the temporal order
// among the entries.
// T is your table.
[Your Measure] =
var __indexesOfInterest =
SELECTCOLUMNS(
ADDCOLUMNS(
SUMMARIZE(
T,
T[Month],
T[Cat],
T[SubCat]
),
"@index",
CALCULATE( MAX( T[Index] ) )
),
"@index", [@index]
)
var __result =
CALCULATE(
SUM( T[Value] ),
TREATAS(
__indexesOfInterest,
T[Index]
),
ALL( T )
)
return
__result
Best
D
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |