Forum Discussion
DAX Help using two tables.
Hi, we have two tables in pbix, "Table1" and "Table2".
and i am trying to replace Table 1 values with Table 2
can anyone help me writing DAX for this requirement?
Thanks in advance.
Hi yodha ,
Or you can create a measure as below:
Measure = IF(MAX('Table'[Name]) in FILTERS('Table (2)'[Name])&&MAX('Table'[Group])="False"&&MAX('Table'[Type])="False"&&MAX('Table'[Sub-type])="False",FORMAT(CALCULATE(MAX('Table (2)'[Value]),FILTER('Table (2)','Table (2)'[Name]=MAX('Table'[Name]))),"fixed"),MAX('Table'[Value]))And you will see:
For the related .pbix file,pls click here.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
2 Replies
yodha how these two tables are connected, if the relationship between these two tables is 1 to many and one side of the relationship is table2, you can new column with the following expression:
New Column = IF ( Table1[Name] IN { "Standard", "Enterprise" }, Table1[Group] = FALSE() && Table1[Type] = FALSE() && Tab1e1[Sub Type] = FALSE(), RELATED ( Table2[Value] ), Table1[Value] )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Hi yodha ,
Or you can create a measure as below:
Measure = IF(MAX('Table'[Name]) in FILTERS('Table (2)'[Name])&&MAX('Table'[Group])="False"&&MAX('Table'[Type])="False"&&MAX('Table'[Sub-type])="False",FORMAT(CALCULATE(MAX('Table (2)'[Value]),FILTER('Table (2)','Table (2)'[Name]=MAX('Table'[Name]))),"fixed"),MAX('Table'[Value]))And you will see:
For the related .pbix file,pls click here.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
