Time date Matrix

hi  Anonymous 

For your case, you could try this way as below:

Step1:

Create two calculate columns that

Weekday = FORMAT([Date],"dddd")

Weekday num = WEEKDAY([Date],2)

Step2:

You'd better change the data type for [Time] column as below:

Step3:

Create a simple measure

Measure = COUNTROWS(Sheet1)

Step4:

then create a matrix as below:

Of course, you'd better set the sort by column for weekday column.

https://radacad.com/sort-by-column-in-power-bi

and here is sample pbix file, please try it.

Regards,

Lin