Forum Discussion
Calendar function can not be Blank value.
- 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
What is the data source for AllSupportTickets table? - Jira - Rest API i think.
I have checked the All Support Tickets table and it is empty, only the headings.
I am unsure why this has stopped getting the data.
The reports are dynamic which i think the reports were set up with DAX, they report on the previous 12 months from the current month along with other date ranges 😞
Hi Gem-M ,
Beacuse AllSupportTickets table can't get data, I suggest you could create calendar by calendar(date(2020,1,1),today()), use today() or fixed date, then create relstionship between AllSupportTickets and calendar table, which should work.
You also could check whether AllSupportTickets can't get data is caused by credential problem or network problem.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
