Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need some help with combining dates for displaying in a matrix, see below blue highlights ie. "1/Feb - 3/Feb" , "4/Feb - 10/Feb", "11/Feb - 17/Feb", "18/Feb - 24/Feb", "25/Feb - 28/Feb"
Week 5 |
1/Feb - 3/Feb |
Mon-Thu |
Fri-Sat |
Week 6 |
4/Feb - 10/Feb |
Mon-Thu |
Fri-Sat |
Week 7 |
11/Feb - 17/Feb |
Mon-Thu |
Fri-Sat |
Week 8 |
18/Feb - 24/Feb |
Mon-Thu |
Fri-Sat |
Week 9 |
25/Feb - 28/Feb |
Mon-Thu |
Fri-Sat |
Currently, the Date table has these columns:
Date Date/Month DayRange DayShortName
01/02/2019 1/2 Fri - Sun Fri
02/02/2019 2/2 Fri - Sun Sat
03/02/2019 3/2 Fri - Sun Sun
04/02/2019 4/2 Mon - Thu Mon
05/02/2019 5/2 Mon - Thu Tue
06/02/2019 6/2 Mon - Thu Wed
07/02/2019 7/2 Mon - Thu Thu
08/02/2019 8/2 Fri - Sun Fri
09/02/2019 9/2 Fri - Sun Sat
10/02/2019 10/2 Fri - Sun Sun
.. and so on...
I have tried this but it returned the same min and max date.
Any help on this would be appreciated. Thanks
Solved! Go to Solution.
Hi @Anonymous ,
To achive the desired result, please go through the following steps.
Step1: Convert date into Week Start. Go to Edit Queries, and do as in the below screenshot.
Step2: Convert date into Week End. Same as above but select Week of End.
Make sure to choose the date format for the newly added columns.
Step3: Convert Week Start Date into DD/MMM. Use the below dax script.
Step5: Combine results to get the desired output.
Final Result = [Week Start] &" - "& [Week End]
This will give you that what you are looking for.
I have tested this and it is working fine.
Final Output will be like.
Please let me know if you have any questions. Happy to help you.
Regards,
Pavan Vanguri.
Hi @Anonymous ,
To achive the desired result, please go through the following steps.
Step1: Convert date into Week Start. Go to Edit Queries, and do as in the below screenshot.
Step2: Convert date into Week End. Same as above but select Week of End.
Make sure to choose the date format for the newly added columns.
Step3: Convert Week Start Date into DD/MMM. Use the below dax script.
Step5: Combine results to get the desired output.
Final Result = [Week Start] &" - "& [Week End]
This will give you that what you are looking for.
I have tested this and it is working fine.
Final Output will be like.
Please let me know if you have any questions. Happy to help you.
Regards,
Pavan Vanguri.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |