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.
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |