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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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
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