Forum Discussion
Solved
Help with IF ISBLANK AND formula
Hi I'm trying to do a formula but I got stuck at the below: =IF(ISBLANK([@[Date Completed]]),"",IF(AND([@[Date Completed]]<=[@[Due Date]]), "Completed on Time", "Completed Late")) I want i...
Hi Row89
(dates in dd/mm/yy format)
in D2:
=IFS( AND(ISNUMBER([@[Date Completed]]),ISBLANK([@Status])), "Missing status", [@Status] <> "completed", "", ISBLANK([@[Date Completed]]), "Missing completed date", AND(ISNUMBER([@[Date Completed]]),[@[Date Completed]]<=[@[Due Date]]), "Completed on time", TRUE, "Completed late" )
I don't have a PowerBI account so can't reply on the PowerBI community. Could be something like:
= Table.AddColumn(PreviousStepName, "Comment", each
if ([Date Completed] is date and [Status] is null) then "Missing status"
else if [Status] <> "Completed" then null
else if [Date Completed] is null then "Missing completed date"
else if ([Date Completed] is date and [Date Completed] <= [Due Date]) then "Completed on time"
else "Completed late",
type text
)
