Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

calculate column datediff

Hai,   I used a calculated column to calculate a time between 2 dates        time = DATEDIFF(item[syscreated];now();DAY)   I have a database with 100.000 rows, after a scheduled refresh i've go...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi,

     

    I removed the calculated column to the SQL statement in the SQL Server Management Studio.

    Now i don't see the problem anymore.

     

    Strange, I thougt that all the data changes can be made in the query-editor. Perhaps not

Dog's avatar
Dog
Icon for Responsive Resident rankResponsive Resident
9 years ago

Hi Anonymous

 

I would imagine that a calculate column is the best way forward assuming that you are wanting to report on the actual values rather than an aggregation. 

 

Were you viewing this through the service? or do you have the same issue when viewing through PBI desktop?

 

When you view the data in the model does the calculated column show the data ok. I am just trying to establish whether it's just a problem with the visual and not your formula. easiest way to test is to use SSMS and query the model to show the table data. 

I've had a problem before where the dataset hadn't refreshed properly in the service after adding a new calculated column. 

 

Dog