"The visual object cannot be displayed" formula to complex?

[Anonymous]

Hi everyone I am trying to add a calculated field, but I have an error called "The visual object cannot be displayed", the problem is that I can more column with simpler calculations. 

The formula used is 

DayAssignmentToday = DATEDIFF( 'public account'[assigned_manager_date],TODAY(),DAY) 

And I have the following message (I made the translation to English]

I already checked the field has the data type date. 

Best Regards

[v-easonf-msft]

Hi , @Anonymous 

It seems that similar issues have been raised by other users  here.

https://community.powerbi.com/t5/Issues/Redshift-with-DATEDIFF-Function-Throws-Expression-Error/idi-p/1086773

https://community.powerbi.com/t5/Issues/OLE-DB-or-ODBC-Error-Expression-Error-We-couldn-t-fold-the/idi-p/630511

You can keep an eye on the status of them.

BTY,It is recommended to create a support ticket to investigate this issue.
https://powerbi.microsoft.com/en-us/support/

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @amitchandak I was trying to find another solution but still, I am having the same issue. Basically I generated three new columns called

assigned_manager_date_YEAR = YEAR('public account'[assigned_manager_date])
assigned_manager_date_MONTH = MONTH('public account'[assigned_manager_date])
assigned_manager_date_DAY = DAY('public account'[assigned_manager_date])

Then I made a date column 

assigned_manager_date_DATE = DATE('public account'[assigned_manager_date_YEAR],'public account'[assigned_manager_date_MONTH],'public account'[assigned_manager_date_DAY])

but that column is already corrupted 

Hence the final column is as well corrupted 

DayAssignmentToday = DATEDIFF( 'public account'[assigned_manager_date_DATE],TODAY(),DAY)

I have to hide some information 

Thank you

[amitchandak]

@Anonymous , seem strange looking at the formula. Can you share sample data ? Or a sample pbix after removing sensitive data.

[Anonymous]

Hi amitchandak, thank you for your email.  The relevant information just consist of a column with dates 

assigned_manager_date

1/1/2020 12:00:00 AM

1/1/2020 12:00:00 AM

12/31/2019 12:00:00 AM

1/1/2020 12:00:00 AM

1/1/2020 12:00:00 AM

1/1/2020 12:00:00 AM

1/1/2020 12:00:00 AM

7/31/2020 12:00:00 AM

1/16/2020 12:00:00 AM

I am attaching an image now with PowerBi in english

Thank you

Mauricio