Forum Discussion

Paskk's avatar
Paskk
Regular Visitor
3 years ago
Solved

Create a new column using conditions

Hi, I would like to create the "Supplier administration service" column in the input table in which the first corresponding valid value of Supplier is indicated for each distinct building in the cont...
  • ThxAlot's avatar
    ThxAlot
    3 years ago

     

     

    Admin Service = 
IF(
    BLDG[Service] = "Cleaning service",
    COALESCE(
        CALCULATE(
            MAX( BLDG[Supplier] ),
            ALLEXCEPT( BLDG, BLDG[Building] ),
            BLDG[Service] = "Administration service"
        ),
        "No One"
    )
)

     

ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
3 years ago

 

 

Admin Service = 
IF(
    BLDG[Service] = "Cleaning service",
    COALESCE(
        CALCULATE(
            MAX( BLDG[Supplier] ),
            ALLEXCEPT( BLDG, BLDG[Building] ),
            BLDG[Service] = "Administration service"
        ),
        "No One"
    )
)