Forum Discussion

Ramendra's avatar
Ramendra
Icon for Helper IV rankHelper IV
6 years ago

Running net promoter score

Hi team, I want to make a graph where I want see the nps progress from day 1 to current day for a current month. I don't want nps per day but I want running nps. For example if first day positive, ...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Ramendra ,

 

Currently, it is not supported to add time to date hierarchy in Power BI.

 

As a workaround, you may use series of TIME functions to get Time column, format the data type of Time column as "hh:mm:ss" or other format, and create measure like DAX below to get cumulative NPS value.

 

Column: Time = TIME(HOUR('Table'[Created]),MINUTE('Table'[Created]),SECOND('Table'[Created]))

Measure: NPS value = CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Created]<=MAX('Table'[Created])))

 

Finally, you can choose Matrix visual to display result, add Time column to Columns box of Matrix visual behind date field.

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ramendra's avatar
Ramendra
Icon for Helper IV rankHelper IV
6 years ago

Hi But your screenshots showing the data for feb and March also. But I have given data only for april.

I want to see MTD for april at a perticular time for example I want MTD NPS on 3rd april till 3 PM.

Can you please help.

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Ramendra ,

     

    Did you test using the formulas above?

      

    Best Regards,

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.