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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Ranveer_Bhati
New Member

previous quarter is not working for current month power bi

Hi
 I am new to Power BI and Dax. My report worked fine for all the quarters but it shows nothing when I select the current quarter's month. 

First image when i selected Dec.23 and second image shows Jan.24 data

 

Ranveer_Bhati_0-1707898585767.png

 

 

 

Please help

 

https://drive.google.com/file/d/1xvDx0P2ye_n0EeVyjNyuhArK8F1w3qsF/view?usp=drive_link

2 REPLIES 2
Anonymous
Not applicable

Hi @Ranveer_Bhati ,

It doesn't look like there is anything wrong with your data structure or DAX, it seems that in the existing Filter case there just isn't any data that matches the current filter criteria.

vjunyantmsft_1-1707962812941.png

When I clear this filter, it shows some data:

vjunyantmsft_2-1707962852067.png


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Dino,
The data structure or DAX works perfectly. I use the Previous Period function to get the previous quarter's data but it doesn't work for the current quarter.
that's why I posted it on the forum to get the solution.

Regards

Ranveer

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

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.

Top Solution Authors