Forum Discussion
Solved
Calendar function can not be Blank value.
Hello, Please can someone help, i have reports that have worked previously and have now stopped. The error that comes up on the web: "Couldn't load the data for this visual The query refer...
- What is the data source for AllSupportTickets table?
If you haven't made any changes to the report, looks like something has changed in the AllSupportTickets table - either the [created] column has been renamed or removed, or the table changed, or there is possibly a relative date filter in the Power Query that has now made that created column empty.
You'll want to figure out what's happening with that table, but as a quick fix you can put an actual date in the formula instead:
CALENDAR (DATE(2020,01,01), eomonth(Today,2))
I personally prefer using M/Power Query to create my data table rather than DAX, but that's just a suggestion. I reserve DAX for dynamic calculations and measures rather than creating data loaded into the model.
https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
What is the data source for AllSupportTickets table?
If you haven't made any changes to the report, looks like something has changed in the AllSupportTickets table - either the [created] column has been renamed or removed, or the table changed, or there is possibly a relative date filter in the Power Query that has now made that created column empty.
You'll want to figure out what's happening with that table, but as a quick fix you can put an actual date in the formula instead:
CALENDAR (DATE(2020,01,01), eomonth(Today,2))
I personally prefer using M/Power Query to create my data table rather than DAX, but that's just a suggestion. I reserve DAX for dynamic calculations and measures rather than creating data loaded into the model.
https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
If you haven't made any changes to the report, looks like something has changed in the AllSupportTickets table - either the [created] column has been renamed or removed, or the table changed, or there is possibly a relative date filter in the Power Query that has now made that created column empty.
You'll want to figure out what's happening with that table, but as a quick fix you can put an actual date in the formula instead:
CALENDAR (DATE(2020,01,01), eomonth(Today,2))
I personally prefer using M/Power Query to create my data table rather than DAX, but that's just a suggestion. I reserve DAX for dynamic calculations and measures rather than creating data loaded into the model.
https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
Looks like it was a credential problem for the AllSupportTickets table which in turn caused the other errors.
Thank you for your time and assistance everyone.