Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

calculated column does not work in published report - only in desktop app

Hi, I have a report detailing (among other things) how long certain processes have taken from their start date to their end date in working days. There is a date table ("Date") in the data model t...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Anonymous ,

    Please try updating the data and republishing PBIX on Desktop.

     

    Please check whether the added data is in the same format as the data source, from the calculated column formula we can find that column [SubmittedHelper] , column [HelperCompleted] and column [[isweekday]] are in text format.

     

    Best Regards,

    Neeko Tang

    If this post helps, then please considerAccept it as the solution to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you, making sure that the fields are the same format (whole number in this case) has solved the issue. 

Many thanks Anonymous 

the new formula for the calculated column (in case anyone is interested) looks like this
("is weekday" has replaced TRUE with 1)

Duration Days GDD = if(SearchResults[SubmittedHelper]=0,0, if(SearchResults[HelperCompleted]=0,
CALCULATE(COUNTROWS ( 'Date'),DATESBETWEEN ( 'Date'[Date],SearchResults[Submitted Date]  , SearchResults[Today]  ),
    'Date'[isweekday] = 1, ALL ( SearchResults )),
 CALCULATE(COUNTROWS ( 'Date'),DATESBETWEEN ( 'Date'[Date],SearchResults[Submitted Date]  , SearchResults[Completed Date]  ),
    'Date'[isweekday] = 1, ALL ( SearchResults ))))