How can I group dates and put them in one column

[ligalbert]

I want the following result in powerbi where one column has week to week dates 

 I have the following on powerbi. Is there a way where I can group all the dates from 5/4/2021 - 5/10/2021 so I just have one row with all the answers like shown above 

 

[amitchandak · Accepted solution]

@ligalbert , Create a date from date time 

Date = datevalue([Datetime])

Then create a date table join on a date and have a column like that there

Week  = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1  &  " - "   'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

where(Monday week)

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)