Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 ...
General Comment
Need Help
Show and Tell
Tips and Tricks
stenford23's avatar
stenford23
Helper I
4 years ago

 

 

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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi stenford23 

 

I should try this method/code in advanced editor or how?

 

Regards,

Nuha

  • stenford23's avatar
    stenford23
    Helper I
    4 years ago

    Yes Anonymous  insert this code in advanced editor

    replace original_table with previous step name

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi stenford23 ,

       

      Sorry I dont quite understand. Please refer as below for my advanced editor

       

       

       

      Regards,

      Nuha

       

      • stenford23's avatar
        stenford23
        Helper I
        4 years ago

        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)