Forum Discussion
Solved
Get Monthly data from cumulative data
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
Got the answer
MOnthly Devices =
VAR preval =
CALCULATE(MAX(pbi[devices]), pbi[date] < EARLIER(pbi[date]), REMOVEFILTERS(pbi))return
pbi[devices]-preval
1 Reply
Got the answer
MOnthly Devices =
VAR preval =
CALCULATE(MAX(pbi[devices]), pbi[date] < EARLIER(pbi[date]), REMOVEFILTERS(pbi))return
pbi[devices]-preval