Moving Columns Headers to Rows

[A_a_a]

Hi All!

I have some columns, which show minutes based on calculation time minus time (end time - start time).

I want to create matrix table showing total minutes during the hours by day:

Is there any way to have dates as columns and hours as rows? To get such result:

Please advice.

Thank you,

G.

[Anuja_Chaudhari]

first I have created this data and you would need to create a calculated table or use DAX measures to generate the desired result.

Hope you get this helpful. 

[Greg_Deckler]

@A_a_a In Power Query Editor, try unpivoting your time columns.

[A_a_a]

Hi @Greg_Deckler 

Thank you for your message.

I don't think I can unpivot them because they are not in power query editor, the columns are added in Data View.

What do you think?

Thanks,

G.

[Greg_Deckler · Accepted solution]

@A_a_a Well, perhaps you could move the calculations to PQ and then unpivot. Otherwise, you could potentially use this: DAX Unpivot - Microsoft Power BI Community. Last thought, create a disconnected table that just lists your times like:

Time

0:00

1:00

2:00

Use this for your rows. Create a measure like this:

Measure =
  VAR __Time = MAX('DisconnectedTable'[Time])
  VAR __Result = 
    SWITCH(__Time,
      "0:00", SUM('Table'[0:00]),
      "1:00", SUM('Table'[1:00]),
      "2:00", SUM('Table'[2:00]),
      ...
    )

[A_a_a]

Hi @Greg_Deckler 

Thank you!