Forum Discussion

jonbox's avatar
jonbox
Icon for Helper II rankHelper II
4 years ago

Cumulative result per month

Hi, i'm trying to create a measure that accumulates the result per month so that when shown in the line graph, taking the total as an example to be 2.0m in may, 11m june, 11.8m in july, 12.3 in augus...
Need Help
truptis's avatar
truptis
Icon for Community Champion rankCommunity Champion
4 years ago

Hi jonbox ,

Create a rank (ID_MONTH) column for sorting it properly by month wise. Then use the below measure:

Quantity_CUMULATIVE =
CALCULATE (
[ActualPrediction_USD,
FILTER (
ALL ( Tablename[ID_MONTH] ),
Tablename[ID_MONTH]
<= MAX ( Tablename[ID_MONTH] ) - 1
)

)