search

sql-bi / DaxDateTemplate

Power BI template to create a Date table in DAX
MIT License
265 stars 76 forks source link

RealtiveWeek Position #52

Closed ColinEyres closed 3 years ago

ColinEyres commented 3 years ago

Hi Guys,

I noticed other sites say current calendar week is 5, yet the SQL BI Date says current week is 6, which starts Feb 7 - 13, 2021.

The relative week positions correctly shows 0 for days Jan 31 to Feb 6, 2021.

This was working before really well, but now it doesn't. Last year was a leap year.

I tried getting the latest version of your template - same issue.

Looking at the cut offs between 2020 and 2021, I can see 2 days as Week 1 when it should be week 53. image

Screenshot 2021-02-03 133238 PNG

image

marcosqlbi commented 3 years ago

You shouls use the FW prefixed columns, which follow the fiscal week structure.

ColinEyres commented 3 years ago

I see. Thanks for the fast response Marco!