Forum Discussion
Max Date joined to itself
Hi MORDax ,
According to your description, here's my solution.
In Power Query, select Asset column, then click Group By tab under Transform ribbon.
Set it like this.
Get the result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have one date column, I want to duplicate it, make the date column max and then join it to itself. The underlying rows have multiple entries for a single asset if it was inspected twice, I just want one entry for each asset. That is why.
Asset Date
1 4/25/2022
2 4/24/2022
1 4/22/2022
3 4/21/2022
My final output should contain assets for their latest date
Community SupportHi MORDax ,
According to your description, here's my solution.
In Power Query, select Asset column, then click Group By tab under Transform ribbon.
Set it like this.
Get the result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.