Issue now resolved. Ok so the automated overnight refresh also failed, but this time referring to a completely different table. This time the sourc...
Hi, Just to share with any readers, for clarity i've now selected every one of the applied steps to each of the data tables in the model. On sel...
Thank you Riny, i've made some progress using your recommendation and introduced the Calendar Table. Cheers
Hi Mynda, (apologies if i should have created a new post and happy to do so if needed) Using the logic you provided with a Formula solution, we hav...
Thank you Riny, appreciated
Hi Riny, my apologies - see attached (kutubee.xlsx). fyi I'm using MS Excel 365 on Windows I've applied the formatting and then refreshed the da...