Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove same occurrence if a value is found

Hi there,   I was trying to figure out for a whole day but no result so far.   The idea is when Login txn is posted for each User, any txn that comes with the same DateTime should not be acknowle...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    Mariusz 

    Table.Group(#"Changed Type", {"User", "DateTime"}, {{"Txn", each if List.Contains( _[Txn], "Login" ) then { "Login" } else _[Txn], type list }})

    That is super slick!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Mariusz thank you. It works perfectly.