Separate Values with Distinct Date

marc_frei, do you want to keep distinct rows?

If so, locate the table button on the left of the first column name, click the little arrow near this button. From the pop-up menu that will appear, click Remove Duplicates.

Or: select all columns and Home->Reduce Rows-> Remove Duplicates 

Hi marc_frei , 

I  am not clear  about your requirement, if you want to remove dulicated value, I think you could refer to above suggestions , choose all column and click remove reduplicated. 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("zdExDoQwDAXRu6RGyE5CbJ8Fcf9rLJu0eAoqmlA8fRFNzrOoNC/b/ZH7FN1l7FV0lGt7MANzsMhNBUzBKvxv7uzZKlgD62AH2AAzMAeL3FbPxKCLUpe5c+iZWAPrYAfYADMwB4vcVs/EoItSl7kL6JlYA+u5feku620TG2AG5mABXQQMuih1+e+qvN9dPw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [id = _t, amount = _t, date = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"id", Int64.Type}, {"amount", Int64.Type}, {"date", type date}}),
    #"Removed Duplicates" = Table.Distinct(#"Changed Type")
in
    #"Removed Duplicates"

 If not, please correct me and inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.