Forum

Hi Anders, I think that is exactly what I was thinking of. This could possibly work for what I need. If this isn't the solution I will upload an...

Thanks Mynda. I have taken a look and it is really useful. I need to work out how to get the pro-rata values into the lists. I will take a look.

Hi Mynda, Understand now. In this case I always want to pick up the last date so I don't need to include the TodaysDate bit. Thanks again for y...

Hi, Take a look at the attached. I have added my own data table which shows the Sunday week end dates between 07/01/24 and 25/02/24. I want to indi...

Thanks Teacher, consider my knuckles rapped. I will figure it out and let you know how I did it 🙂

Hi Mynda, Thanks for the file. Is there any way I can pick up the last date in the "W/E Date" column instead of the current date in the TodaysDate ...

Hi Mynda, I am not understanding the bit about pasting the data into a table in Power BI. I can re-create the query in power BI but I would have to...

Hi Mynda, Thanks for getting back to me. There is lots of data, hundreds of thousands of rows so creating a static table using the method prescribe...

Hi, I was just looking at a similar issue again where I have already created a query that doesn't change but still refreshes every time I update ot...