Forum Discussion
Lookupvalue value error
Hello everyone, I was hoping you could help me out. I was trying to do a look up function, but I was getting an error because it has duplicate values. I figured I would try this Calculate but it didn...
Anonymous
how do you define 'grab the first one'? by date?
i create a simple sample data for testing
try to create a column
Column =
MAXX(FILTER(TableA,TableA[orderid]=TableB[orderid]&&'TableA'[date]=MINX(FILTER(TableA,TableA[orderid]=TableB[orderid]),'TableA'[date])),TableA[value])