Forum Discussion
JoHo_BI
Responsive Resident
Responsive ResidentDirectQuery hangs with the Today function
Hi all, I have a very simple matrix which shows order numbers by client. I've added a custom column in the orders table to query whether the date is today, which is the following: _IsToday =...
Hi JoHo_BI,
I can't reproduce your issue, your formula works well on my side. Can you ensure you have correctly configation the datasource?
In addition, if you can please share some detail information about your issue, it will be help for troubleshooting.
Regards,
Xiaoxin Sheng
JoHo_BIHi Anonymous - Thanks for your reply,
Please find a link for a small test dataset available.
In the top right, there is a "IsToday" filter, using the formula from the original post. It however does not load and still throws the error.
The datasource works perfectly, I can pull in data as you can see on the table on the left.