Forum Discussion
Solved
Multiplying column with different values in another table
Hello Everyone, I need help, the case is the next: I have a table with a lot of transactions (invoiced sales, quantities, part numbers) and I have another table with the white list price by count...
You can have new columns like
white list price = Minx(filter('white list price','white list price'[country] ='transactions '[country] ),'white list price'[price]) or white list price = Minx(filter('white list price','white list price'[country] ='transactions '[country] && 'white list price'[item] ='transactions '[item]),'white list price'[price])
amitchandak
Super User
Super UserYou can have new columns like
white list price = Minx(filter('white list price','white list price'[country] ='transactions '[country] ),'white list price'[price])
or
white list price = Minx(filter('white list price','white list price'[country] ='transactions '[country] && 'white list price'[item] ='transactions '[item]),'white list price'[price])