Adding week of year to date hierarchy

[GerardContlx]

Hello everyone,

How can I add the year week to the date hierarchy?

Sorry I'm amaterur.

[bcdobbs]

Hi @GerardContlx 

You need to build a custom date table.

https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/

Something a long lines of the above but with an extra line which produces a week number:

https://docs.microsoft.com/en-us/dax/weeknum-function-dax

You can then relate the table to your date field to create your hierachy.

[bcdobbs]

If you share a demo file I can add a date table to it for you.

[GerardContlx]

I don´t know hay can I upload the file.

[AllisonKennedy · Accepted solution]

@GerardContlx  Make sure you mark your Date table as a Date table - see my blog here on how to do that: https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html

Once you mark it as a date table, that date hierarchy will disappear. You'll then need to re-create it manually and can add Week and any other fields you want to it: 

https://radacad.com/what-a-power-bi-hierarchy-is-and-how-to-use-it