Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi , @Anonymous
It seems that similar issues have been raised by other users here.
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.
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
@Anonymous , seem strange looking at the formula. Can you share sample data ? Or a sample pbix after removing sensitive data.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |