Forum Discussion

ss89's avatar
ss89
Helper II
3 years ago
Solved

Comparison between two columns from different queries

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.