Forum Discussion

ExceLover's avatar
ExceLover
Frequent Visitor
2 years ago
Solved

Convert Excel formula to DAX

Hello,   I am trying to create a new column in Power BI named PEN where each row in this column is a calculation based on values in three other columns.   The formula in Excel is as below, but I ...
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    hi ExceLover ,

     

    try like:

    column = 

    SWITCH(
        TRUE(),
        ISBLANK([C2Column]), 0,
        ISBLANK([A2Column]), 0,
        1
    )

FreemanZ's avatar
FreemanZ
Super User
2 years ago

hi ExceLover ,

 

try like:

column = 

SWITCH(
    TRUE(),
    ISBLANK([C2Column]), 0,
    ISBLANK([A2Column]), 0,
    1
)

ExceLover's avatar
ExceLover
Frequent Visitor
2 years ago

Hi FreemanZ 

 

Thank you for the suggestion, this works as it should.

 

Thanks for your help!