Forum Discussion

momihaila's avatar
momihaila
Frequent Visitor
8 years ago
Solved

Rolling calculation for filtered data

Hi all,   I am fairly new to Power BI and I want to build a NPS dashboard. I have the detailed data at questionnaire level and I am struggling to get rolling kpi's.   I managed to get 2Months rol...
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago

    momihaila

    Thanks for posting those details, which makes your requirement crystal clear. You can try a measure as

    aa prom roll1 =
CALCULATE (
    COUNTAX (
        FILTER ( CallCenter_Interact, CallCenter_Interact[NPS Segment] = "Promoter" ),
        CallCenter_Interact[INT ID]
    ),
    DATESINPERIOD (
        CallCenter_Interact[End of Month],
        LASTDATE ( CallCenter_Interact[End of Month] ),
        -2,
        MONTH
    )
)