Forum Discussion
Basic Beginners Question. Getting a value from another table into a table
Hi all I am trying do something simple. I have a table with a quantity and I want to multiply it by value per unit to get a total value. I am trying to pull that value into the table using Lookup...
Anonymous ,
Try using below measure
Salesprice = LOOKUPVALUE('Sales Price Per Unit'[$ Sales Price Per Unit], 'Sales Price Per Unit'[ProductId], [ProductId])
TotalValue = [Quantity] * Salesprice
I fixed the table so the column was no longer a text and is now a number and it worked. Thanks again for your help and the Measure