Forum Discussion

RvdHeijden's avatar
RvdHeijden
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

Trying to transform an excel formula into Dax :)

Hello,   Im trying to transform my Excel formula into DAX but obviously it doesn't work. Can someon help me in transforming this formula into DAX ??   Status Civiel = IF(Activiteit="Civiel";IF(t...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Which fields/columns are flagged as Date? For example, if "taken[Begin]" is a Date field, then you can't do a comparison to a text value of "", You would have to use "taken[Begin] <> BLANK()" instead.

RvdHeijden's avatar
RvdHeijden
Icon for Post Prodigy rankPost Prodigy
9 years ago

Greg_Deckler

The Colums Taken[Gesloten], [Geopend] and [Begin] are datecolumns

Ive change my formula so that "" becomes BLANK() but it now reads a syntax error

 

Status Civiel =
IF(Taken[activiteit]="Civiel";
     IF(taken[Gesloten]<>BLANK();
          "Gesloten";
          IF(and(taken[geopend]<>BLANK();taken[gesloten]=BLANK());
               "Lopend";
               IF(taken[begin]<>BLANK;
                     "Gepland";
                     "Nog niet gepland"
                 )
            )
       )
  )

RvdHeijden's avatar
RvdHeijden
Icon for Post Prodigy rankPost Prodigy
9 years ago

Greg_Deckler

Just i was posting my reply ive noticed one of the BLANK didnt have the () behind it.

I fixed it and now the formula works......

 

Status Civiel =
IF(Taken[activiteit]="Civiel";
     IF(taken[Gesloten]<>BLANK();
          "Gesloten";
          IF(and(taken[geopend]<>BLANK();taken[gesloten]=BLANK());
               "Lopend";
               IF(taken[begin]<>BLANK();
                     "Gepland";
                     "Nog niet gepland"
                 )
            )
       )
  )