Forum Discussion
Resolver IDates - Future, Past and Blank (null) - conditional formatting
Hi - Probably did this the long way round but created a custom column called Due Service?
New 'Due?' column in the data view:
Then used that for the conditioning on the NEXT DATE column:
This seems to work, thanks for the feedback.
Resolver IHi Samarth - The entry for the ISBLANK entry returns Overdue:
Community ChampionStevenHarrison ,Please try this:-
column =
SWITCH (
TRUE (),
[next date] < TODAY (), "Overdue",
[next date] >= TODAY (), "Not Due",
[next date] = BLANK() , "N/A"
)- StevenHarrison
Hi Samarth - Thank you for the prompt reply, still returns the blank value as 'Overdue', is there a power query way to encompass the null value instead?
- StevenHarrison
Hi Samarth - Tried the following as a custom column and returns the values I need, can you see any issues with this?
if [NEXT DATE] is null then "N/A"
else if [NEXT DATE] <= Date.From(DateTime.LocalNow()) then "Overdue"
else "Not yet Due"- StevenHarrison
Hi - Probably did this the long way round but created a custom column called Due Service?
New 'Due?' column in the data view:
Then used that for the conditioning on the NEXT DATE column:
This seems to work, thanks for the feedback.
- Samarth_18
is it possible for you to share your PBIX file after removing sensitive data?