Need help in DAX for Table Filter

[mgnikhil]

Hi,

My table has Drwaing Number REVISION And Actual Date. Same drawing have different rivision and different date. I just want filter drawing number with latest revision and latest date.

[d_gosbell]

So it would be simple enough to create a calculated column that would return "True" if the current row held the latest revision (or latest date). But I'm not sure how you want to check both conditions. What happens when they conflict and the latest revision does not have the latest date? Can you post some example data and show which rows you would like to be selected?