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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

The calculated column formula works fine in my test. I didn't get the same message after I refresh the data manually.

 

In your scenario, was only data updated after the schedule refresh, was the data type or table structure changed?

 

Did the error occur only in table visual? How about this calculated column in data view?

 

Regards,
Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    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