Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
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 2021
and 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 2020
Thanks before
Solved! 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])
or
Week Year = if([Week Num]=53, year([Week Start date]),[Year])
Now use week year, you should be able to get desired result
@chu_en , we can week year
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week Year = year([Week Start date])
or
Week Year = if([Week Num]=53, year([Week Start date]),[Year])
Now use week year, you should be able to get desired result
Thank you so much, it's work hopefuly, Power BI make this into native function without formulas 😊
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!