i have Week Number in End of 2020, and its a leap year, and the 53 week is start from 28 Dec 2020 till 03 Jan 2021and when i'm using the average of week, the year is divide in 2020 & 2021, how i can make the week 53 year is still in 2020Thanks before
Go to Solution.
@chu_en , we can week year
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week Year = year([Week Start date])
Week Year = if([Week Num]=53, year([Week Start date]),[Year])
Now use week year, you should be able to get desired result
View solution in original post
Thank you so much, it's work hopefuly, Power BI make this into native function without formulas 😊
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.