Forum Discussion

ChristianRHouen's avatar
ChristianRHouen
Icon for Helper III rankHelper III
6 years ago
Solved

Pivoting maximum date for group

Hi all   I want to pivot my data by group and maximum data. See suggested solution below: I'm not sure this is the correct approach to do it, but it was the one that seemed most logical to m...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    You should be able to do this with Power query. Refer the Screenshots below. 

    Under Transform -> Group By -> Advanced (Radio Button)

    Under Operation-> Select the Date Column-> Select option MAX()

    Upon calculating the MAX Date Values. Not Select the Column and Click on UnpivotColumns Option.

    Best Regards,
    Vignesh M

    If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

You should be able to do this with Power query. Refer the Screenshots below. 

Under Transform -> Group By -> Advanced (Radio Button)

Under Operation-> Select the Date Column-> Select option MAX()

Upon calculating the MAX Date Values. Not Select the Column and Click on UnpivotColumns Option.

Best Regards,
Vignesh M

If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)