Forum Discussion

akshayraom's avatar
akshayraom
Frequent Visitor
3 years ago
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    ...
  • akshayraom's avatar
    akshayraom
    3 years ago

    Got the answer

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

    return
    pbi[devices]-preval

akshayraom's avatar
akshayraom
Frequent Visitor
3 years ago

Got the answer

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

return
pbi[devices]-preval