DAX Help using two tables.

[yodha]

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.

[Anonymous · Accepted solution]

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,
Kelly

Did I answer your question? Mark my post as a solution!

[parry2k]

@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.⚡