Trying to convert this excel formula to dax

[benjaminhoang]

Hello this formula count the date to see if it is +1 from today or blank it will count it as part of the pipe and if it is not it will show is not pipe but I would be happy if it just showed pipe and nulls. Can anyone help me please?

=IF(ISBLANK(DISPATCH!N22048),"PIPE",IF(DISPATCH!N22048<TODAY()+1,"NOT PIPE","PIPE"))

[themistoklis · Accepted solution]

@benjaminhoang

Create a new column and not a measure and add the following formula:

New_Column = IF(ISBLANK(Dispatch[Date]),"PIPE",if(Dispatch[Date]<(TODAY()+1),"NOT PIPE","PIPE"))

[Anonymous]

You can try this: 

=if(ISBLANK(Dispatch[Date]);"PIPE";if(int(Dispatch[Date]-TODAY())=1;"NOT PIPE";"PIPE"))

You might have to change the ";" for the ",". It will depend on your regional settings.

The date today is 30th of November

You should see if it is not better to prepare the information with M instead of doing it in DAX.