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
Credit to Enterprise DNA for setting me on this path (Get Power BI Previous Week Values Using DAX & Power Query (enterprisedna.co))
I can't seem to find the formula to properly offset the week numbers. I've tried looking up the Microsoft Offset function explanation but I am incredibly lost.
What I'm trying to achieve is the current week shows as 0, the previous week shows at -1 and next week would be one.
I have tried the following but I know it will trip me up when the year changes:
@Anonymous I know that Melissa de Korte's date table includes a week offset. Otherwise, you could try Sequential: Sequential - Microsoft Fabric Community. Might have to modify it a bit for your specific requirements.
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!