Forum Discussion

Unknowncharact0's avatar
Unknowncharact0
Regular Visitor
2 years ago
Solved

Quarter to Quarter Count Dynamic

Hello,

 

In a KPI card, I need to show # of cases closed last fiscal quarter and # of cases closed in a quarter before that.

I achieved this with filter measure however, my measure is manual, I need help making the measure dynamic, that way it continues to roll over automatically each quarter. I also want the title of the KPI card to be dynamic, to show the name of the previous fiscal quarter. I appreciate your help 🙂

Fiscal Quarters are:

Q1 - October, November, December

Q2 - January, February, March

Q3 - April, May, June

Q4 - July, August, September

 

Attaching a sample of my power bi
https://1drv.ms/u/s!Anb0OMw34A1igQIWI8hTAFoSNsux?e=HYchpx