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

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.