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.
Community ChampionHi MORDax
What do you mean by "max date for each row"? Do you have multiple date columns ans you want to calculate the max out of them? Can you share some sample data?
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
v-yanjiang-msftCommunity Support
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.
