Forum Discussion

siddrow's avatar
siddrow
Icon for Helper III rankHelper III
4 years ago
Solved

Help with converting excel formula to Power BI

Hi   I'm after some help to convert the below excel formula so I can create a custom column in my Power BI query     =IFS( AND(ISNUMBER([@[Date Completed]]),ISBLANK([@Status])), "Missing s...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi siddrow 

    Thanks for reaching out to us.

    You can try this measure

    Measure = 
SWITCH(TRUE(),
MIN('Table'[Status])=BLANK(),"Missing status",
MIN('Table'[Status])<>"completed","",
MIN('Table'[Date Completed])=BLANK(),"Missing completed date",
MIN('Table'[Date Completed])<=MIN('Table'[Due Date]),"Completed on time",
"Completed late"
)

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi siddrow 

Thanks for reaching out to us.

You can try this measure

Measure = 
SWITCH(TRUE(),
MIN('Table'[Status])=BLANK(),"Missing status",
MIN('Table'[Status])<>"completed","",
MIN('Table'[Date Completed])=BLANK(),"Missing completed date",
MIN('Table'[Date Completed])<=MIN('Table'[Due Date]),"Completed on time",
"Completed late"
)

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.