Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Unknowncharact0
Regular 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 🙂

Unknowncharact0_0-1704467927393.png

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 ACCEPTED SOLUTION
ThxAlot
Super User
Super User

ThxAlot_0-1704490042433.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LearnAndPractise(Everyday)


)



View solution in original post

1 REPLY 1
ThxAlot
Super User
Super User

ThxAlot_0-1704490042433.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LearnAndPractise(Everyday)


)



Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.