Min - Max date display based on Week number

Question

Hi,&nbsp;I need some help with combining dates for displaying in a matrix, see below blue highlights ie.&nbsp;"1/Feb - 3/Feb"&nbsp;, "4/Feb - 10/Feb", "11/Feb - 17/Feb", "18/Feb - 24/Feb", "25/Feb - 28/Feb"&nbsp;&nbsp;Week 51/Feb - 3/FebMon-ThuFri-SatWeek 64/Feb - 10/FebMon-ThuFri-SatWeek 711/Feb - 17/FebMon-ThuFri-SatWeek 818/Feb - 24/FebMon-ThuFri-SatWeek 925/Feb - 28/FebMon-ThuFri-Sat&nbsp;&nbsp;Currently,&nbsp;the Date table has these columns:Date&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date/Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DayRange&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DayShortName&nbsp;01/02/2019&nbsp;&nbsp;&nbsp;&nbsp; 1/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fri - Sun &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fri02/02/2019&nbsp;&nbsp;&nbsp;&nbsp; 2/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fri - Sun &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sat03/02/2019&nbsp;&nbsp;&nbsp;&nbsp; 3/2&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;Fri - Sun&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;Sun04/02/2019&nbsp;&nbsp;&nbsp;&nbsp; 4/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Mon - Thu&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mon05/02/2019&nbsp;&nbsp;&nbsp;&nbsp; 5/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Mon - Thu &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tue06/02/2019&nbsp;&nbsp;&nbsp;&nbsp; 6/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Mon - Thu &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; Wed07/02/2019&nbsp;&nbsp;&nbsp;&nbsp; 7/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Mon - Thu &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thu08/02/2019&nbsp;&nbsp;&nbsp;&nbsp; 8/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fri - Sun &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fri09/02/2019&nbsp;&nbsp;&nbsp;&nbsp; 9/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fri - Sun &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sat10/02/2019&nbsp;&nbsp;&nbsp;&nbsp; 10/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fri - Sun&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;Sun.. and so on...&nbsp;I have tried this but it returned the same min and max date.FormatDate = CONCATENATE(CONCATENATE(CALCULATE(MIN('Date'[Date/Month]), GROUPBY('Date', 'Date'[DayRange]))&nbsp;&nbsp; , "-") ,&nbsp; CALCULATE(MAX('Date'[Date/Month]), GROUPBY('Date',&nbsp; 'Date'[DayRange])&nbsp;&nbsp;&nbsp; ))&nbsp;Any help on this would be appreciated. Thanks&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;To achive the desired result, please go through the following steps.&nbsp;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.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Week Start = FORMAT(SELECTEDVALUE(Dates[Start of Week]),"DD/MMM")Step4: Convert Week End Date into DD/MMM. Use the below dax script.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Week End = FORMAT(SELECTEDVALUE(Dates[End of Week]),"DD/MMM")Step5: Combine results to get the desired output.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Final Result = [Week Start] &amp;" - "&amp; [Week End]&nbsp;This will give you that what you are looking for.I have tested this and it is working fine.Final Output will be like.&nbsp;Please let me know if you have any questions. Happy to help you.&nbsp;Regards,Pavan Vanguri.

Forum Discussion

Min - Max date display based on Week number

1 Reply

Related content

Get number of days in displayed month.

Measure either displays all same number or incorrect

Visual Display based on Filter/slicer election

Image display in Power bi report

Change numbers to display as thousands or milions