Forum Discussion
Looking up values based on two variables
Hi Anonymous ,
Please refer to my pbix file to see if it helps you.
Create a column.
Column = VAR datelive = LOOKUPVALUE ( Refference[DateLive], Refference[SKU], Transactions[SKU] ) RETURN IF ( Transactions[PurchaseDate] >= datelive, "Live", "Not live" )If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This will work. Thank you so much
Hi Anonymous ,
Please refer to my pbix file to see if it helps you.
Create a column.
Column =
VAR datelive =
LOOKUPVALUE ( Refference[DateLive], Refference[SKU], Transactions[SKU] )
RETURN
IF ( Transactions[PurchaseDate] >= datelive, "Live", "Not live" )
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This will work. Thank you so much
Hi Anonymous ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.