start a matrix table at 7am

Question

Hi I have a matrix table that has hours in the column and store in the row with a count of employees as the value

Currently it defaults to start at midnight through to 11pm. I want it to start at 7am through to 6am. Is there a way to do this.

store	0	1	2	3	4	5	6	7
A	10	15	12	10	8	5	8	9

store	7	8	9	10	11	12	13	14
A	9	20	15	10	15	18	8	9

Thank you

lbendlin · Answer

yes, read about "Sort a column by another column".&nbsp; This assumes you have a dedicated hour column in your table.

amirabedh · Answer

You can create a&nbsp;calculated column that adjusts the hour values to fit the desired range :&nbsp;ShiftedHour = 
    IF(
        'Table'[Hour] &gt;= 7, 
        'Table'[Hour] - 7, 
        'Table'[Hour] + 17
    )&nbsp;Now you can use the ShiftedHour column instead of the original hour column.

maurcoll · Answer

Hi that works as it renames the 6 to 23 which is what i need but i still need to use the original column in my matrix and sort by that so in the matrix the 6 still needs to show as 6 not 23.This is what i need it to look like, hours from midnight to 6am are from the following day. so i need the day to start at 7 am through to 6 am the next day on each row. Hope that makes sense. I have tried creating a conditional column and sort by but that doesnt seem to work either. The hour column how it is imported from teh DWH is stored as a number and i cant amend that.&nbsp;7891011121314151617181920212223012345611/07/2024&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12/07/2024&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13/07/2024&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14/07/2024&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15/07/2024&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;16/07/2024&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;