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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a report in which I update monthly to display the most recent 2 months of invoices in a matrix. Currently, I'm doing this by hand in the filter panel, see the picture below. I want to automate this through a DAX measure mostly because I have to do this for 6 different pages. I couldn't get this to work though with my other ranking measure. Any ideas? Link below has the Power BI file.
https://drive.google.com/file/d/1TjwEc3EQYvNZ37XizMT4xZmP-eIO_S3_/view?usp=sharing
@Anonymous , I think the Rank column on the month can be a good idea.
Month year = format([Date], "YYYYMM")
Rank COlumn = rankx(all(Table), [Month year])
Now you can select 1,2
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!