Hi - Thank you both for taking time to respond. Given I'm using Excel Get Data from web, I thought someone may have run into this error before....
Thanks Mynda, I agree that it maybe a dependency issue. Especially since the file eventually refreshes and I get the desired results. I'll fini...
Dear Mindy, Sometime you just need someone to take a fresh look to get steered in the right direction. The measure results are perfect. Can't t...
Morning Mynda, The measure works great. Thank you for your quick response. I spent most of the weekend trying to find something that would work. ...
Thank you, Mynda. That's what I thought. Enjoy your day.
OMG! Yes it is working... When I cleaned up the file (removed a number of tabs etc.) to attached the file to this request it must have cleaned up ...
Dear Catalin, Thank you so much for the help yesterday. As the file was originally created in 2017, it was using an older method of date table dev...
Hi Catalin, Attached is the screen shot file - apologies! I've dug deeper and added other screen shots on Connection2 tab. I'm pretty confident...
Thank you SunnyKow and Mynda! Both answers were helpful, but as I plan to load the query table into Power Pivot, Mynda's response best fit my needs...