Power Query

[Andrei]

Hi all,

I need to solve the following problem in Power Query . I need to find tha max of the date column per client and repeat that information in a separate column until the client name changes. I know how to do this in Excel, but this data is imported in Power Query from a different source, so i need to solve this in Power Query. Can't find an easy way to compare rows in Power Query.

Please find bellow a data sample.

Kind regards,

Andrei

Client	Repayment	Date	Required
abc	$10	01/02/2019	01/12/2019
abc	$10	01/03/2019	01/12/2019
abc	$10	01/04/2019	01/12/2019
abc	$10	01/05/2019	01/12/2019
abc	$10	01/06/2019	01/12/2019
abc	$10	01/07/2019	01/12/2019
abc	$10	01/08/2019	01/12/2019
abc	$10	01/09/2019	01/12/2019
abc	$10	01/10/2019	01/12/2019
abc	$10	01/11/2019	01/12/2019
abc	$10	01/12/2019	01/12/2019
xyz	$12	01/01/2022	01/11/2022
xyz	$12	01/02/2022	01/11/2022
xyz	$12	01/03/2022	01/11/2022
xyz	$12	01/04/2022	01/11/2022
xyz	$12	01/05/2022	01/11/2022
xyz	$12	01/06/2022	01/11/2022
xyz	$12	01/07/2022	01/11/2022
xyz	$12	01/08/2022	01/11/2022
xyz	$12	01/09/2022	01/11/2022
xyz	$12	01/10/2022	01/11/2022
xyz	$12	01/11/2022	01/11/2022

[Zubair_Muhammad · Accepted solution]

Hi @Andrei 

You can do it from Query Editor's user interface as follows.

Then Expand the AllRows Column

[Andrei]

Thanks for your help, but this is just filtering the table by client and showing me the max date for that client. i need it unfiltered with that max date repeating on a different column until the client name changes.