Forum Discussion

AsmaAlNashash's avatar
AsmaAlNashash
Frequent Visitor
3 years ago
Solved

Switch Case based on NULL values

Hi, I am currently trying to do something very simple. I want to create a new column in which if only the first column is Not Null, the value will be 1. If the First and Second columns are not Null t...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Asma,

    I have created dummy data for your reference, hopefully your requirement is fulfilled.

    Note: You can use LOOKUPVALUE Dax in order to get columns from different tables.

    Dax - 

    Column =
    Var a= if(ISBLANK('Table (2)'[Column1]),0,1)
    var b = if(ISBLANK('Table (2)'[Column2]),0,1)
    var c = if(ISBLANK('Table (2)'[Column3]),0,1)
    var d = if(ISBLANK('Table (2)'[Column4]),0,1)
    Var e = a+b+c+d
    return e


    Please refer to the below image.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Asma,

I have created dummy data for your reference, hopefully your requirement is fulfilled.

Note: You can use LOOKUPVALUE Dax in order to get columns from different tables.

Dax - 

Column =
Var a= if(ISBLANK('Table (2)'[Column1]),0,1)
var b = if(ISBLANK('Table (2)'[Column2]),0,1)
var c = if(ISBLANK('Table (2)'[Column3]),0,1)
var d = if(ISBLANK('Table (2)'[Column4]),0,1)
Var e = a+b+c+d
return e


Please refer to the below image.