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 ,
I want to drop the yellow highlighted row and remain the not highlighted row.
Because as you can see in the red highlighted data is different.
Regards,
Nuha
Table.Distinct(
Table.Buffer(
Table.Sort(
original_table,
{"End Time", Order.Ascending}
)
), {"Usage (Unit)}"
)
Sort by End date (add start date also if you need it), Buffer it (otherwise it won't work) and get distinct.
Yes Anonymous insert this code in advanced editor
replace original_table with previous step name
Hi stenford23 ,
Sorry I dont quite understand. Please refer as below for my advanced editor
Regards,
Nuha