The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
User | Count |
---|---|
78 | |
73 | |
37 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |