Forum Discussion

pedroccamaraDBI's avatar
pedroccamaraDBI
Post Partisan
3 years ago
Solved

pivot or transpose?

Hello everyone I have this table on the left and I want to have the table on the right Can you please help me on how to do this?  Thanks in advance
Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    3 years ago

    sure. follow the image.

     

    1. open power query

    3. select any column except CLOCK_DATETIME (make sure it is date time type)

    2. transform > pivot >>pivot on CLOCK_DATETIME 

    expand advanced option. select do not aggregate. 

     

    do not aggregate will keep your value same, whereas aggregating value will for example count will only count different dates. In this case value will be 1. as you have one date only. you can open power query and play around with the agg functions to better understand. Let me know if you need to solution file. 

    and voila!

     

     

     

Syk's avatar
Syk
Resident Rockstar
3 years ago

Select your clock type column > Transform > Pivot Column > Make sure your value column is your datetime and the aggregation is set to "Don't Aggregate"

 

pedroccamaraDBI's avatar
pedroccamaraDBI
Post Partisan
3 years ago

Thank you for your answer Syk 

Just to understand, is there any difference between "with no aggregation" and selecting MAX or MIN instead?