Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX IF Function with 2 connected tables

Hey guys,   I'm new to the world of DAX Formulas and would need a bit of a help with an "IF" Function.   I have 2 tables that are connected to each other based on service ID: "Service Dashboard" ...
Need Help
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    A calculated column like this might help:

    BU Status =
VAR BU = 'ServiceDashboard'[Business Unit]
VAR HasRed =
    CONTAINS (
        'ServiceDashboard',
        'ServiceDashboard'[Business Unit], BU,
        'ServiceDashboard'[Service Status], "red"
    )
VAR HasYellow =
    CONTAINS (
        'ServiceDashboard',
        'ServiceDashboard'[Business Unit], BU,
        'ServiceDashboard'[Service Status], "yellow"
    )
RETURN
    IF ( HasRed, "red", IF ( HasYellow, "yellow", "green" ) )
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

Could you please share some sample data to me? You could upload your report to your OneDrive and send the link to me.

 

Regards,

Daniel He

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hey Daniel,

     

    just sent you a private message!

     

    Many thanks,

     

    Adam