Forum Discussion
boolittlek
8 months agoFrequent Visitor
Query references other queries or steps, so it may not directly access a data source
Hi, Newbie here. I'm trying to calculate a delta between two dates in my query (RequestedCompletionDate and ActualCompletionDate). I found ImkeF's Networkdays function and was able to use it in...
- 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.
V-yubandi-msft
8 months agoCommunity Support
Thank you for sharing your approach.