Transform Excel Formula to Power Query

[Tom8558]

I would like to implement the solution above in Power Query from Power BI.
In the end, I want only the data to be loaded that has the value "FALSE" in the "Remove" field. This field is not in the original table.
Thanks in advance

Tom

[tharunkumarRTK · Accepted solution]

@Tom8558 

I have taken a data sample and transformed the excel formula to m-code 

 

Table.AddColumn(#"Changed Type", "Remove Filed", each let
__A = [A],
__B = [B],
__FilterB = Table.SelectRows(#"Changed Type", each [B] = __B)[A],
__MaxValue = List.Max(__FilterB)
in 
[A] < __MaxValue)

You can find the file here: Link

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun