Power BI Formula Required
Budget: $10 – $30 AUD
I want to create a custom column with a formula in power bi. The formula in excel is as per below, however when i do it the same in BI it doesnt appear to work:
=IF(AttendanceDueDate>ActualFirstAttendanceDate,”KPI Achieved”,IF(AttendanceDueDate<ActulFirstAttendanceDate,”KPI Not Achieved”,IF(1stAttendaceDueTime>ActualFirstAttendanceTime,”KPI Achieved”,”KPI Not Achieved”)))
=IF(AttendanceDueDate>ActualFirstAttendanceDate,”KPI Achieved”,IF(AttendanceDueDate<ActulFirstAttendanceDate,”KPI Not Achieved”,IF(1stAttendaceDueTime>ActualFirstAttendanceTime,”KPI Achieved”,”KPI Not Achieved”)))