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

I have a different scenario now, I need 3 new columns that contain either 1 or 0 in the rows, based on the values in the rows in the columns DCP, ULS and TLS.

 

The pseudocode is:

 

New column 1 =

If DCP is >=0 then value should be 0, otherwise;

               If ULS is >=0 then value should be 0, otherwise;

                              If TLS is >=0 then value should be 1, otherwise should be 0

 

New column 2 =

If DCP is >=0 then value should be 0, otherwise;

               If ULS is >=0 then value should be 0, otherwise;

                              If TLS is >=0 then value should be 1, otherwise should be 0

 

New column 3 =

If DCP is >=0 then value should be 1, otherwise;

               If ULS is >=0 then value should be 0, otherwise;

                              If TLS is >=0 then value should be 0, otherwise should be 0

 

Please could you suggest the DAX formulae I should use for the 3 new columns?