Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |