I’m trying to create an initial value from a table that uses multiple criteria.
Table example (Sales):
Customer | Promo | Available Qty
Steve | Apple | 2
Steve | Pear | 3
Something like SELECT(Sales[Available Qty], [Customer] = [_THISROW].[Customer], [Promo] = [_THISROW].[Promo]))
So, it would create a single initial numerical value of 2 for Steve if the promo was Apple, and 3 if the promo was Pear
It doesn’t seem to work that way, and I also tried using nested SELECT statements. Any ideas?