Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Asa94
Helper I
Helper I

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:

 

Asa94_0-1664267615302.png

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

1 ACCEPTED SOLUTION
Tiemen
Advocate II
Advocate II

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/

 

View solution in original post

2 REPLIES 2
Tiemen
Advocate II
Advocate II

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 @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!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.