Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Comparting values from different tables based on conditions

Hey guys!   I'm having troubles trying to compare values from two different tables. The situation is the following: I have two tables, "Enhancements" and "Budget", and I need to compare a value tha...
Need Help
Show and Tell
Tutorial Requests
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi RSCHMIDT,

 

Create a calculate column on Budget Table using DAX like this:

 

 

Compare Cost =
SWITCH (
    [Cost status],
    "Planned", LOOKUPVALUE (
        Enhancements Table[Cost],
        Enhancements Table[ID], Budget Table[ID],
        Enhancements Table[Cost Status], "Estimated "
    ),
    "actual", LOOKUPVALUE (
        Enhancements Table[Cost],
        Enhancements Table[ID], Budget Table[ID],
        Enhancements Table[Cost Status], "confirmed"
    )
)

Regards,

 

Jimmy Tao

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-yuta-msft

 

Thanks a lot for the reply!

 

Your code doesn't seem to be doing anything. What I need to do is, compare the costs on both tables, so I can know which are different and which have the same value, so I can show them and etc.