Forum Discussion

Moniek's avatar
Moniek
Resolver I
3 years ago
Solved

Show only rows with the same value

Hi I have a table with many transactions including date, amount, description and other columns. Now I want to see only the lines with the same amount? How can solve this? Thanks
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Moniek , create a new column

     

    cnt = Countx(filter(Table, Table[Amount] = earlier(Table[Amount])) , Table[Amount])

     

    You have filter cnt> 1 in visual

amitchandak's avatar
amitchandak
Super User
3 years ago

Moniek , create a new column

 

cnt = Countx(filter(Table, Table[Amount] = earlier(Table[Amount])) , Table[Amount])

 

You have filter cnt> 1 in visual