COMPARING COLUMNS FROM TWO TABLES

[Anonymous]

Hello! 

I need to compare the values from two different tables to confirm if they are equal or not into a new column

For example: 

If Table 1 Row 1 equals Table 2 Row 1, then "true"

If Table 1 Row 2 does not equal Table 2 Row 2, then "false"

Table 1              Table 2 

54                        54

64                        66

25                        13

87                         87

[Anonymous]

Why are you trying to do it in DAX instead of Power Query, where such a calculation truly belongs? On top of that, you do not have any unique identifier on which you could pair up rows.

My suggestion - as always - is to use the right tool for the job. The right tool is Power Query.

Best

Darek

[Anonymous]

 Hello Darek!

There is a seperate column on both tables that relates the two and is a unique identifier. Same key for every related row.

How would you reccommend I build this in power query?

[Anonymous]

Hello Darek,

I have a similar case where I need to calculate with values from different tables in Power BI. I need to build up a huge database which could not be handled by Power Query. That´s why I am usind Power BI now.

In this database, I have for example one table with ACTUALS 2012-2018 and another one with GROWTHRATES 2019-2025. What I´d like to do now is calculate the acutal values for 2019-2025. I have a unique key.

As I have one column "Year" in both of these tables, I would additionally need to filter for the same period, so that I do not calculate for example ACT 2018 x Growthrate 2024. The growthrate always needs to be multiplied with the previous year.

Do you have any idea how I could do this? Every hint is highly appreciated!

Thanks a lot for your support!

Sabine

[Anonymous]

Sabine,

Would you please create a separate post for this? And please give some more information because now I can't tell you anything. I'd like to see some pics, if possible, the layout of the model and maybe a picture that would explain what you want to do.

Thanks.

Best
Darek