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”)))
33 freelanceria on tarjonnut keskimäärin $23 tähän työhön
Hello, I can help you with the formula for your column in PowerBI, please send me a message with more details and if its possible with the .pibx file so I can check it and can start working on it inmediately
hi, I can assist you in fixing that formula in PowerBI. It just needs a fine tuning to get the desired result. Available to assist to get your work done. Thanks, SP
Hello, I can easily create the IF formula using DAX expression, which is used by Power BI. The project can be delivered within a few hours depends on the time zone.