Date Range for Weeknum

[Asa94]

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

[Tiemen · Accepted solution]

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/

[Asa94]

Hi @Tiemen,

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!