Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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/
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!
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |