Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Karim Mohsni]

Hi all

I have a table in which there are lines (invoices) that repeat themselves. I want to create a column in which I copy the amount of each invoice for the first time and put a zeros for the duplicates. below is an example.

Thanks for any help

——————————
Karim Mohsni
Auditor
——————————

[Feras Alramli]

Hi ,

The best way to remove duplicate by using Power Query

Go to Power Query —> Home –> Highlight Invoice N & Invoice date —-> click in Reduce Rows — > Remove Duplicate.

Thanks,
Feras?

——————————
Feras Alramli
Mississauga ON
——————————
——————————————-

[Karim Mohsni]

Hi Fera
I don’t want to eliminate the duplicate row, but just to remove the duplicate amont of invoice.
Thank’s Firas

——————————
Karim Mohsni
Auditor
——————————
——————————————-