Forum Discussion

NeilJustice's avatar
NeilJustice
Frequent Visitor
2 years ago

remove rows in a table based on a condition.

  I have a table imported into power BI (sample below) i want to be able to filter either the table or when i create a visual that will only show me the row with the highest Transaction Id, in this ...
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, NeilJustice 

You can try to make new table 

Addcolumn ('yourtable',"hightranid", calculate (maxx ( filter ('yourtable','yourtable'[Invoice id]), 'yourtable'[Transaction id])))

 

You can make new measure which use instead of transaction Id column 

 

New measure= 

maxx ( filter ('yourtable','yourtable'[Invoice id]), 'yourtable'[Transaction id])

 

 

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.