Forum Discussion
Solved
Networkdays with filter function
Hi All, I want to calculate Turn Around Days of the tasks by filtering couple of columns. I am using below formula, but its showing as error. Please help me on this. TAD1 = CALCULATE(FILTER('Dr...
FreemanZ ,
Thanks for your response 🙂
Now I have slightly modified it and its working fine. I wanted an average value of turn around days on a monthly basis by filtering few columns. Here is the modified version
TAD1 = CALCULATE(AVERAGEX('Drawing & Design Review Tracker',NETWORKDAYS('Drawing & Design Review Tracker'[Received Date],'Drawing & Design Review Tracker'[Delivery Date])),FILTER('Drawing & Design Review Tracker','Drawing & Design Review Tracker'[Drawing/Design]="Drawing"&&'Drawing & Design Review Tracker'[Release Status]="Before Release"))
FreemanZ ,
Thanks for your response 🙂
Now I have slightly modified it and its working fine. I wanted an average value of turn around days on a monthly basis by filtering few columns. Here is the modified version
TAD1 = CALCULATE(AVERAGEX('Drawing & Design Review Tracker',NETWORKDAYS('Drawing & Design Review Tracker'[Received Date],'Drawing & Design Review Tracker'[Delivery Date])),FILTER('Drawing & Design Review Tracker','Drawing & Design Review Tracker'[Drawing/Design]="Drawing"&&'Drawing & Design Review Tracker'[Release Status]="Before Release"))