Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
benjaminhoang
Helper III
Helper III

Trying to convert this excel formula to dax

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"))

1 ACCEPTED SOLUTION
themistoklis
Community Champion
Community Champion

@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"))

View solution in original post

2 REPLIES 2
themistoklis
Community Champion
Community Champion

@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
Not applicable

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 NovemberThe 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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.