Need help with Dax calculation : For 4 Quarter Rolling%

Hi ProdPal ,

Based on the sample data Below is the result. 

And the measure is:

Rolling $ Quarter _ Promoter % = 
var stat = max('Table'[ Response Date])-365
var B = date(year(stat),month(stat),1)
RETURN
calculate(COUNT('Table'[NPS Group]),ALLEXCEPT('Table','Table'[NPS Group]),'Table'[ Response Date]>=B,'Table'[ Response Date]<=max('Table'[ Response Date]))

TO get the percentage, go to the value pane, put show value as percentage of row total.

Let me know If this works. Plz accept as solution if works.

Hi ProdPal ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Rupak_bi for the prompt response.

I have created PBIX file using sample data, please go through the attached PBIX file.

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

Thank you.

Hi ProdPal ,

I wanted to check if you had the opportunity to review the information provided.If the response has addressed your query, please accept it as a solution, so other members can easily find it.

Thank you.