Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |