Comparison between two columns from different queries

[ss89]

Hello Community,

I need to make a comparison between two columns, "Week Planned Out" and "Week Out" that come from two different queries.

When I try to do the IF formula and compare whether the "Week Planned Out" is greater than "Week Out", I cannot select columns from other different queries

How can I do this?

Thanks in advance for your help!

[Anonymous · Accepted solution]

Hi @ss89 ,

Please try below steps:

1. below is my test table

Table:

Table2

Table3:

Table4:

Model:

2. try below dax formula

has relationship:

Column = IF([Sale]>RELATED('Table'[Cost]),"+","-")

no relationship:

Column =
VAR cost =
    LOOKUPVALUE ( 'Table 3'[Cost], 'Table 3'[Product], 'Table 4'[Product] )
RETURN
    IF ( [Sale] > cost, "+", "-" )

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Do you try the solution define here : https://www.spguides.com/power-bi-compares-two-columns-in-different-tables/ ?