Forum Discussion
StevenHarrison
Resolver I
Resolver IDates - Future, Past and Blank (null) - conditional formatting
Hi Guys - I have a [NEXT DATE] column with Future, Past and null dates (in Power Query Editor displayed as null and as (Blank) in Data view). I want to be able to conditionally format a table visual...
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.
StevenHarrisonResolver I
Resolver IHi 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"
StevenHarrisonResolver I
Resolver IHi - 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.