Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
3 years ago

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

  • bsheffer's avatar
    bsheffer
    Continued Contributor

    when you created the is working day calculated field it populated the view in the data tab okay?

     

     

     

    • ArchStanton's avatar
      ArchStanton
      Power Participant

      yes it did. I've created a new calendar date table now and it seems to have fixed the issue.

      Thanks!