Endofweek doesn't have values for the last week of Year

[wangfeng9981]

Marco,
When I implement DAX Date Template v.1.14 Calendar into my project, I found if I set up the one year (2020) calendar, the last Week 12/27/2020 - 1/2/2021 for the FW EndOfWeek is 1/2/2021, but that value is empty (or null); see the screenshot

If I want to get the year 2020 end week Week 12/27/2020 - 1/2/2021 for the FW EndOfWeek value, I need to set up two years (2020 & 2021) calendar. Is this the only way to get the ending week value if this cross to next year?

Thank you very much!

[marcosqlbi]

Can you specify which parameters did you use?
If you evaluate the WeeklyFiscalPeriods (replace Result with WeeklyFiscalPeriods at the end) you can see the fiscal periods evaluated - for FW2020 the last day is 12/26/2020 and 12/27/2020 is the first week of FW2021.
By changing the parameter you might obtain a different result, but I'm not sure about your requirements.