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

Can you explain more which rows you expect to drop or keep and why?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

    • 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