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 gives me null values instead of blank values.
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,

1 Reply

  • 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,