Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Change the formula to the following one:
Change the formula to the following one:
hi themistoklis,
yes thats work. but in combination with the year i get following problem:
normally the CW53 should belong the year 2020. Something like YEAR(calender(date), 21) would be nice 🙂
for my x-axis i use:
Here is a solution from 2016:
Solved: Need help creating week number - Microsoft Power BI Community
Is it still current?
I think this formula may help you.
Year = IF(WEEKNUM('Calendar'[Date], 21)=53, YEAR('Calendar'[Date]) - 1, YEAR('Calendar'[Date]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |