Urgently need help , with Calculating 4 Quarter Rolling % Of NPS Groups.

[Radz2707]

Here's my Sample data ,

Index Year Quarter Response Date NPS Group

1	2025 Q1	2025-01-15	Promoter
2	2025 Q1	2025-01-15	Passive
3	2025 Q1	2025-01-15	Detractor
4	2025 Q1	2025-01-22	Promoter
5	2025 Q1	2025-01-22	Passive
6	2025 Q1	2025-01-22	Detractor
7	2025 Q1	2025-01-29	Promoter
8	2025 Q1	2025-01-29	Passive
9	2025 Q1	2025-01-29	Detractor
10	2025 Q2	2025-04-05	Promoter
11	2025 Q2	2025-04-05	Passive
12	2025 Q2	2025-04-05	Detractor
13	2025 Q2	2025-04-12	Promoter
14	2025 Q2	2025-04-12	Passive
15	2025 Q2	2025-04-12	Detractor
16	2025 Q2	2025-04-19	Promoter
17	2025 Q2	2025-04-19	Passive
18	2025 Q2	2025-04-19	Detractor
19	2025 Q3	2025-07-10	Promoter
20	2025 Q3	2025-07-10	Passive
21	2025 Q3	2025-07-10	Detractor
22	2025 Q3	2025-07-17	Promoter
23	2025 Q3	2025-07-17	Passive
24	2025 Q3	2025-07-17	Detractor
25	2025 Q3	2025-07-24	Promoter
26	2025 Q3	2025-07-24	Passive
27	2025 Q3	2025-07-24	Detractor
28	2025 Q4	2025-10-05	Promoter
29	2025 Q4	2025-10-05	Passive
30	2025 Q4	2025-10-05	Detractor

In need to calculate % of Promoters , Passive , Detractors in Power BI , 
The formula for Promoter % is (Count of Promoters / Total Count )*100 
My requirement is if I click on 2024 Q3, My Rolling $ Quarter _ Promoter % =  ( Count of Promoters  for Q3 2024 +Q2 2024+Q1 2024+Q4 2023)/(Total Count for  Q3 2024 +Q2 2024+Q1 2024+Q4 2023)*100

In the above sample data i have pasted if I click Q4 2024 in my slicer , I should get Rolling Promoter % ( Q4 2024+Q3 2024+Q2 2024+ Q1 2024)
My output should be in the below format :

Year Quarter Promoter % Passive % Detractor %

2025 Q'1
2025 Q'2
2025 Q'3
2025 Q'4

[v-achippa]

Hi @Radz2707,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Akash_Varuna for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Radz2707,

We wanted to kindly follow up to check if the solution provided by the user resolved your issue.

If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Akash_Varuna]

Hi @Radz2707 For this please follow these steps 

1. Create a Rolling Total measure for each NPS group using CALCULATE and FILTER to include the last 4 quarters:

   Rolling Total Promoters = CALCULATE(COUNTROWS(tblProjects), FILTER(ALL(tblProjects), tblProjects[Year-Quarter] <= MAX(tblProjects[Year-Quarter]) && tblProjects[Year-Quarter] > MAX(tblProjects[Year-Quarter]) - 4), tblProjects[NPS Group] = "Promoter")

2. Create a Rolling Total All measure for the total count across all groups similarly.

3. Define percentage measures, e.g., Promoter % = DIVIDE([Rolling Total Promoters], [Rolling Total All], 0) * 100.

4. Use a matrix visual with Year-Quarter in rows and the percentage measures in values; filter using a slicer.

[Radz2707 · Accepted solution]

Thanks ! This was really helpful. Apologies for the delayed response, marking this as the solution.