Forum Discussion
Helper VUsing isBlank to return blank when no value provided in a field
Hi CMcMahan,
After futzing w/this a bit, I finally got it to work correctly with this DAX:
Updated PR MS Indicator calc
M_Task MS RYG2 =
If(
isBlank(Max('taskbaselines'[Task Baseline Finish Date])),
BLANK(),
If(MAX('Tasks'[Task Finish Variance Days])<=7,"https://Aristocratgaming.sharepoint.com/sites/pwa/_api/Projectdata/_layouts/15/inc/PWA/images/cf_6p.png" ,
if(MAX('tasks'[Task Finish Variance Days])>=21,"https://Aristocratgaming.sharepoint.com/sites/pwa/_api/Projectdata/_layouts/15/inc/PWA/images/cf_2p.png" ,
)))
Resident RockstarWhen calculating a column, try this to get a single value:
C_Task MS RYG = If(isBlank(EARLIER('Taskbaselines'[task baseline finish date])), BLANK(),
ClintThank you Cmcmahan - this returns the error "earlier/earliest refers to an earlier row context which doesn't exist"
- Cmcmahan
Ugh. I hate messing with EARLIER/EARLIEST.
The root problem here is that when you evaluate this
ISBLANK('Taskbaselines'[task baseline finish date])DAX is returning a list of values. You're asking "Is this value blank?" and giving the function a whole column of values. DAX gives up and tells you there's an error. What you need is a way to select one of those values. Depending on the context you're in, you may be able to use SELECTEDVALUE, RELATED or some other aggregation function to get one value out of the list.
Is the table you're adding this column to the same one the value is in?
- Clint
Hi Cmcmahan ,
No, it's in the Taskbaselines table and column is in the Tasks table. I put an aggregator in (Max) and the calculation doesn't throw an error but it doesn't return the right result either. The RYG indicators are still showing up when the baseline (target) is blank
I can try moving it to the Taskbaselines table to see if that makes a difference.