Get Monthly data from cumulative data

[akshayraom]

Hi All,

I have monthly cumulative data on my devices coulmn , i need to create a new column which gives monthly number

Ex : Current month - previous month

please help with Dax query

[akshayraom · Accepted solution]

Got the answer

MOnthly Devices =
VAR preval =
CALCULATE(MAX(pbi[devices]), pbi[date] < EARLIER(pbi[date]), REMOVEFILTERS(pbi))

return
pbi[devices]-preval