Forum Discussion
multiple ifs with multiple conditions
Hello everyone, I am trying to solve the following issue with multiple ifs and conditions if eventnumber=eventnumber and unit's(starts with BLS or RA) dispatch time is after unit's dispatch time(st...
Hello, I need to add a condition to an already existing formula:
Where Form submitted = 1 AND BOR date = 0 it should calculate days between Form submitted on and today.
IF('PRC Change Management Pipeline List'[Number Form Submitted on]=1,IF('PRC Change Management Pipeline List'[Number BOR updated date number]=1,CALCULATE(COUNTROWS('Calendar'),FILTER('Calendar',WEEKDAY('Calendar'[Date],2)<6),DATESBETWEEN('Calendar'[Date],'PRC Change Management Pipeline List'[Form Submitted on],'PRC Change Management Pipeline List'[BOR updated date]-1))))
Your help will be greatly appreciated 🙂