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" )
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"
)you're a genius, thank you very much!!!
Would this also work in MS Lists as a conditional column or Power BI custom column or would I have to change the format of the formula?
- You're welcome & Thanks for providing feedback
Re. MS Lists no idea as I don't know the product
Re. Power BI/Power Query the same thing can be achieved but the formula will be different as the products don't "share" any function with Excel. If you want an example please open a new discussion - Thanks- Thank you, I've posted it here
https://community.powerbi.com/t5/Desktop/Help-with-converting-excel-formula-to-Power-BI/m-p/2568671#M907966
