Tricky Dimdate Table

[Anonymous]

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 

[amitchandak · Accepted solution]

@Anonymous , Is it same as ISO week ?

Week = weeknum([Date], 21)