Thanks Mynda, You are correct. I have once column called 'channel'. What you suggested has worked. Anita.
Hi Mynda, How would I do this in PQ?
Thank you Riny. This worked perfectly 🙂
Hi Mynda, Yes I did that however I wanted to see AC1,AC2 and AC3 sumed as one value per month instead of 3 seperate lines on the graph. I found an...
Thanks for clarifying this Mynda. I've loaded my file as a pivot chart and I've been working on setting up the tables I need. I've realised that...
Hi, Ok so I've created a query which combines 12 files (1 for each month) and each file contains 5 min data for that month and I'm just not sure wh...
Thank you very much Riny van Eekelen for your assistance. All is now working.
Hi Mynda, Just one thing I noticed. The Day Name is not correct as they all say Saturday. 1/9/22 is Thursday, 2/9 is Friday and 3/9 is Saturda...
Mynda, Thank you so much for taking the time to step me through this. I will definately focus on the power query course now that I know that's my ...
Hi Mynda, Thanks for replying to me! I've attached the data. The coloumns are now different to how I originally described them as I deleted t...