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.
Hi Experts
See attached sample PBIX file....
I need to some how amend the measure i have in the attached file so the date for week one starts in the first full week in each of the following historical years and future years tooo.
So 2019.
First Full Working week 7th Jan 2019
S0 2020
First Full Working week 6th Jan 2020
So 2021
First Full Working week 4th Jan 2021
and the calender to have 52 weeks in the year as a maximum
https://www.dropbox.com/s/hb73z1r63zzvoyh/DimDate.pbix?dl=0
Solved! Go to Solution.
@Anonymous , Is it same as ISO week ?
Week = weeknum([Date], 21)
@Anonymous , Is it same as ISO week ?
Week = weeknum([Date], 21)
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 |
---|---|
107 | |
93 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |