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" )
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
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#M907966I 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 )- Thank you for your help on this, much appreciated!