Forum Discussion
Unknowncharact0
2 years agoRegular Visitor
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
1 Reply
- ThxAlotSuper User