How to latest value with lookupvalue using condition within lookupvalue?

[slav84]

Hi, 
I have table with OrderIds which do repeat sometimes. I have a Column that tells me if is last occurance of that OrderId. The table looks like this. 

I also have another table with Unique OderIds and i need to perform lookupvalue and get the values from Channel column but i need the last value for that Id. So i need to use logic something like, 
Lookup Id from from table1 in table 2 and bring chanel value when "LastOccurance" = "Yes"

How do i do that in Dax?

[amitchandak · Accepted solution]

@slav84 , Create a new column in table 1

maxx(filter(Table2, Table2[OrderId]=Table1[OrderId] && Table2[LastOccurance] = "Yes"),Table2[Channel])

[slav84]

Thank you Amit, this worked. 🙂