Forum Discussion
AdministratorMultiply factor to some products
Hello
I need help with a Dax to be able to multiply by one factor some IDs of the products in a table, in case of not matching the ID only shows the sale in units without applying the factor.
In excel I have this formula:
that formula searches in a table for the IDs with factor, if it finds them it multiplies them and if you do not find them it only shows the units without applying factor
Hopefully you can help me.
Best regards
3 Replies
- amitchandak
Super User
Syndicate_Admin , if the fact is constant
then a new column in table 1
if( Table1[Column] in values(Table2[Column]), [Value]* 1.22 , [Value])
if table 2 has both column and factor to multiply
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8 
Syndicate_AdminThanks, the number is not constant depends on the factor of each ID. How could I do it?
- Syndicate_Admin
I was told that with the dax LOOKUPVALUE it could be, but that formula was not used.
