Forum Discussion
ArchStanton
3 years agoPower Participant
Column Object has an error
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
2 Replies
- bshefferContinued Contributor
when you created the is working day calculated field it populated the view in the data tab okay?
- ArchStantonPower Participant
yes it did. I've created a new calendar date table now and it seems to have fixed the issue.
Thanks!