Forum Discussion
How to latest value with lookupvalue using condition within lookupvalue?
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?
Anonymous , Create a new column in table 1
maxx(filter(Table2, Table2[OrderId]=Table1[OrderId] && Table2[LastOccurance] = "Yes"),Table2[Channel])
2 Replies
- amitchandak
Super User
Anonymous , Create a new column in table 1
maxx(filter(Table2, Table2[OrderId]=Table1[OrderId] && Table2[LastOccurance] = "Yes"),Table2[Channel])