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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Anonymous
Not applicable

Calculate dynamically Week Differnce

Hi ,

I need dax formula to calculate Target column , which differnce of current week and next week .

 

Quarter Year-Week  DiffTarget 
Q2'202020-2686648664
Q2'212020-2708664
Q2'222020-2808664
Q2'232020-2914087256
Q2'242020-3007256
Q2'252020-316726584
Q2'262020-3206584
Q2'272020-3306584
Q2'282020-343706214
Q2'392020-4510493748

 

Thanks

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , preferably move week -year to separate table and create a rank on that

 

Week Rank = Rankx(all(Week],[Week Year],,asc,dense)

 

Now use this rank for next and previous week

This Week = CALCULATE(sum('Table'[Target]), FILTER(ALL('WEEK'),'WEEK'[Week Rank]=max('WEEK'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Target]), FILTER(ALL('WEEK'),'WEEK'[Week Rank]=max('WEEK'[Week Rank])-1))
Next Week = CALCULATE(sum('Table'[Target]), FILTER(ALL('WEEK'),'WEEK'[Week Rank]=max('WEEK'[Week Rank])-1))

 

refer my blog on Week

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors