Making a new column with blank values doesnt change into blank values

[Anonymous]

I tried to make a new column by adding a if statement in dax,

Status ASL = IF ( 'Fct rituitval'[Uitval gedeeltelijk (#)] = 1, "Gedeeltelijk gereden",
IF ('Fct rituitval'[Uitval volledig (#)] = 1, "Niet gereden"))

It makes values that got 1 in 'Uitval gedeeltelijk change into "Gedeeltelijk gereden" and it makes values that got 1 in "Uitval volledig" change into "Niet gereden". Blank values that doesnt has "Uitval gedeeltelijk" or "Uitval volledig" changes into values that duplicate the value "Gedeeltelijk gereden" or "Niet gereden". I just want them to change into the value "Gereden" or it just has to be blank. Why does it duplicate the other values? And can anyone help me out PLS

[v-zhangti · Accepted solution]

Hi, @Anonymous 

Please check the following methods.

Column:

Status ASL =
IF (
    'Fct rituitval'[Uitval gedeeltelijk (#)] = 1,
    "Gedeeltelijk gereden",
    IF ( 'Fct rituitval'[Uitval volledig (#)] = 1, "Niet gereden", "Gereden" )
)

Is this the result you were expecting?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @Anonymous ,

The code seems correct, are you abble to share a sample file?