Forum Discussion
PowerBINoob24
Resolver I
Resolver ICreating an entry based upon a date compared to today
I have a status collumn that populates based upon a date column. It works great except for the highlighted portion. What I need to happen if the Approved Date field is blank and today is later than...
It would be helpful next time (or if this doesn't work) to include some sample data to work with.
The order matters with these statements, so try this instead.
Status Approval = SWITCH ( TRUE (), ISBLANK ('Execution Status'[Approved Date].[Date]) && ('Execution Status'[Due Date].[Date]) < TODAY (), "Overdue", ISBLANK ( 'Execution Status'[Approved Date].[Date] ), "In Process", 'Execution Status'[Approved Date].[Date] < 'Execution Status' [Due Date].[Date], "On Time", "Completed Late" )
PowerBINoob24Resolver I
Resolver IThat did the trick. Thank you so much for your help. Still trying to learn all of this.
KNP
Super User
Super UserHappy to help.