Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
Solved! Go to Solution.
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
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
@anil_patil65 , Try using updated measure
DAX
TAD1 =
CALCULATE(
NETWORKDAYS(
'Drawing & Design Review Tracker'[Received Date],
'Drawing & Design Review Tracker'[Delivery Date]
),
FILTER(
'Drawing & Design Review Tracker',
'Drawing & Design Review Tracker'[Release Status] = "Before Release" &&
'Drawing & Design Review Tracker'[Drawing/Design] = "Drawing"
)
)
Proud to be a Super User! |
|
If I flip the functions, I can't choose Received date and Delivered Date for Networkdays from the 'Drawing & Design Review Tracker' table.
Regards,
Anil Patil
hi @anil_patil65 ,
the first argument for CALCULATE should return a value, instead of a table (like the FILTER expression in your original post), that is why you encountered an error.
CALCULATE can overwrite filter context, so you will not be able to filter the columns as long as you wrap it inside CALCULATE.
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |