Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Can anyone help me with the following please?
This code produces the error below:
Duration from Assigned (wd) = if('Cases'[tpo_layerassigneddate]>0,CALCULATE(
COUNTROWS('Date2'),
DATESBETWEEN('Date2'[Date],'Cases'[tpo_layerassigneddate],'Cases'[Closed & Now] +1),'Date'[Is Working Day] = TRUE(),
ALL('Date2')
))
Is Working Day code =
Is Working Day = IF('Date2'[DayofWkNumber]>5,0,IF([Public Holiday]>1,0,1))
I converted the Format of Is Working Day to True/False but I'm still getting this error.
Any ideas why?
Thanks
when you created the is working day calculated field it populated the view in the data tab okay?
yes it did. I've created a new calendar date table now and it seems to have fixed the issue.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |