Power BI Week Number and Year

[Anonymous]

Hi, I am trying to produce a new column which converts a date field to a week number and year. I have the following DAX formula:

WEEK: WEEKNUM('Overbooking'[DATE]), 

The DATE is in the following format: 05/10/2020 00:00:00.

Which produces a week number in a new column, but does anyone know how I can have the week number and year combined, for example in the following format "41 - 2020". 

[Anonymous · Accepted solution]

Hi @Anonymous ,

As @parry2k suggested, you could simply use FORMAT() function. 

And if you want to calculate week started on Monday instead of Sunday, you could use the following formula:

Column = WEEKNUM([Date],2) &"-"&YEAR([Date])

Please take a look at the differences between these two method:

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous try this

Week Year = FORMAT ( Table[Date], "WW-YYYY" )

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡