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
Gem-M ,
Take out this from min(AllSupportTickets[created]) and check is working or not, what value is it giving ?
CALENDAR (min(AllSupportTickets[created]), eomonth(Today,2)),
or use firstnonblank(AllSupportTickets[created] ,date(2015,01,01)) , that will ensure value you have even it is null.
Also make sure that column is not deleted or rename, if so do the required changes