Forum Discussion
Query references other queries or steps, so it may not directly access a data source
- 8 months ago
I tried removing the holiday component as a parameter in the function and hard-coding a reference to the list object:
I tested it, and the function itself works--I was able to get the correct values by inputting test start and end dates. However, when I use the function in my main query (again, passing only the start and end dates), I still get the "references other queries" error.
I may have to just stick with the combo method (calling the SharePoint list of holidays directly in my main query) or try calculating the delta in a DAX measure.
Hi boolittlek ,
May I know if your issue is resolved? If you need any additional help or further details, please let us know.
Thank you.
Hi--I will proceed with combining everything into a single query. Thanks--I appreciate everyone's advice and suggestions.