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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
manishsalanke
Helper II
Helper II

dynamic last 30 days orders count

we have status column containg completed and pending and we want to show count of pending and completed separately and it want to show it in table which will show last the count for last 30 days dynamically -for example selected date is 15 march this 15days will be counted in 30 days and remaing 15 days count from Feb 

2 REPLIES 2
miTutorials
Super User
Super User

This tutorial should help you achieve what you are looking for.

 

Create slicer with Custom Time Periods in PowerBI | Time Intelligence | MiTutorials - YouTube

thank you for your response ,i have applied the steps suggested in the tutorial but it is not working

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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
Top Kudoed Authors