Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"))
Solved! Go to Solution.
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"))
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"))
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.
You should see if it is not better to prepare the information with M instead of doing it in DAX.