How to format the data in Power query?

[bourne2000]

Hi

I have the below table

I would like to format the above table as below

Basically counting how many times 12 PM or 9 am presents respective to the date. I would like to do the above in Power query as a seperate table. Here is the sample PBIX https://we.tl/t-BHfxKLrJQL

Please advise

[v-yalanwu-msft · Accepted solution]

Hi, @bourne2000 ;

You could use pivot in power query like belows  :

1.Copy the Tour date column.

2.Pivot the copy column.

The final output is shown below:

In addition ,it also can be achieved by matrix.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@bourne2000 , Pivot in power query can do that

https://radacad.com/pivot-and-unpivot-with-power-bi