Forum Discussion
How to remove duplicate with if else condition
Hi all, Want to ask how can I remove duplicate with if else condition? Do it have some formula for that? Current data Data that I want it to be view in powerbi I ...
Hi stenford23 ,
Sorry I dont quite understand. Please refer as below for my advanced editor
Regards,
Nuha
Replace the code i give to you with
drop_duplicates = Table.Distinct(
Table.Buffer(
Table.Sort(
#"Expanded SAP__PPT_EV_ProductionOrderConfirmationAdd (3)",
{"End Time", Order.Ascending}
)
), {"Usage (Unit)}"
)
in
drop_duplicates
Change also what comes after "in" by replacing it with drop_duplicates (as in the code above)