Forum Discussion

BM_'s avatar
BM_
Frequent Visitor
4 years ago
Solved

M code conditional and blank value

Hi, I have the following DAX I would like in M code.   Einddatum = IF(AND([FTXCDBSTATUSPERSON] = "Oud", [Mutatietype]="Einddatum"), [MutatieDatum], BLANK())   How can I do this? Also else null g...
Need Help
  • AilleryO's avatar
    AilleryO
    4 years ago

    Hi,

     

    In M should be like this :

    if [FTXCDBSTATUSPERSON]="Oud" and [Mutatietype]="Einddatum" then [Mutatietype] else null

    should do the trick.

    Becarefull in M Code everything is case sensitive.

    Have a nice day,

AilleryO's avatar
AilleryO
Memorable Member
4 years ago

Hi,

 

In M should be like this :

if [FTXCDBSTATUSPERSON]="Oud" and [Mutatietype]="Einddatum" then [Mutatietype] else null

should do the trick.

Becarefull in M Code everything is case sensitive.

Have a nice day,