Forum Discussion
Date Range for Weeknum
Hi all,
I hope you are well,
I have the following date table for one of the reports I'm doing:
I need to show the date range for the respective Weeknum.
For example, Weeknum 2 has date range: 2 - 8 Jan.
Any tips on how what DAX to use in this instance? Any help would be appreciated 🙂
Kind Regards,
Asa
Hello Asa,
Maybe this article helps. As a final step you can use a concatenate function to make a single column.
https://bielite.com/blog/week-start-date-power-bi-dax/
2 Replies
Hello Asa,
Maybe this article helps. As a final step you can use a concatenate function to make a single column.
https://bielite.com/blog/week-start-date-power-bi-dax/
Hi Anonymous,
That article defintely helped a lot. Did some changes to get the required output and the concatenate function to join the columns.
Thank you so much!
