Forum Discussion

zahidah_mabd's avatar
zahidah_mabd
Helper I
4 years ago

Ignore Blank Value

Hi I have a column [Job Grade] in which I separated the value by delimeter "/" into two new columns [Job_Grade.1] and [Job_Grade.2].  The example data is below: Job Grade Job_Grade.1 Job_Gra...
Need Help
zahidah_mabd's avatar
zahidah_mabd
Helper I
4 years ago

amitchandak 
No it still doesnt work,,, it still consider empty value 2 as incorrect.
Also, I got an error when using  (not(Blank('zhpla'[Job_Grade.1]))  so i use ISBLANK instead .. like  (not(ISBLANK('zhpla'[Job_Grade.1])) but it still doesnt work.

Is it possible to to an IF condition in this case? im not sure how tho. 

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, zahidah_mabd 

    I think you could try treating the blank value as an element in the list as well.

    Output = 
var _jobgrade={"P1", "P2", "P3", "P5", "P6", "P7","A1", "A2","A3", "D1","D2","D3","E1","E2","E3","E4",""}
RETURN
    IF (
        MAX ( zhpla[Job_Grade.1] ) IN _jobgrade
           && MAX ( zhpla[Job_Grade.2] ) IN _jobgrade,
        "Correct",
        "Incorrect"
    )

    Best Regards,
    Community Support Team _ Eason