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
AllisonKennedy
Community Champion
Community ChampionYou could also use
Calendar = CALENDARAUTO()
if you really want a quick fix, but as I said in my first reply, you'll want to figure out what's going on under the hood to have broken it, so check the Power Query and see what steps have been created.
Calendar = CALENDARAUTO()
if you really want a quick fix, but as I said in my first reply, you'll want to figure out what's going on under the hood to have broken it, so check the Power Query and see what steps have been created.