Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Check column if blank or null

Hello, currently working on a project and i encounter some difficulties. 

 

Im trying to check the column using measures if the column KPI has "Blank", "Yes" or "No" entries on that column. The condition would be if KPI column is "blank", the result would be "blank". If KPI column is "No", then the result would be "5" and if KPI column is "Yes" the result should "0". Im done with the Yes and No condition but when im adding the blank part i cant get it right because "Isblank" is only used for measure and i cant put the column name their. Is there any possible way to resolve this? Thanks in advance.!

  • hi Anonymous 

    try to add a calculated column like:

    Column =

    SWITCH(

        [KPI],

       "Yes", 0,

        "No", 5,

        BLANK()

    )

1 Reply

  • hi Anonymous 

    try to add a calculated column like:

    Column =

    SWITCH(

        [KPI],

       "Yes", 0,

        "No", 5,

        BLANK()

    )