Forum Discussion

maurcoll's avatar
maurcoll
Icon for Helper IV rankHelper IV
2 years ago

start a matrix table at 7am

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 7a...
Need Help
AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
2 years ago

You can create a calculated column that adjusts the hour values to fit the desired range :

 

ShiftedHour = 
    IF(
        'Table'[Hour] >= 7, 
        'Table'[Hour] - 7, 
        'Table'[Hour] + 17
    )

 

Now you can use the ShiftedHour column instead of the original hour column.