Forum Discussion
Power BI Week Number and Year
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".
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.
2 Replies
- parry2k
Super User
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.⚡
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.
