Forum

Hi Mynda, Thanks for the response. The issue seems to only be when the file is opening. If I remove the slicer then the file opens ok. I can t...

Hi Velouria, that is exactly what I was after. Works fine. Thanks.

Hi Catalin, I understand what you are saying and it works fine for the "This Year" column. Is there anyway I can reference the same cell but deduct...

Hi Catalin, Thanks for the reply. I know that you can reference a cell as you have but what I was hoping was to have the user select a year and mon...

Hi Catalin, Thanks that works well and another new technique to use. Very useful. I did in fact manage to work out another way to do it. When I ...

Hi Mynda, That worked perfectly but I have now come across another related issue. I added a merged column to the query that pulls together the entr...

Hi Mynda, Consider my wrists well and truly slapped 🙂 I did try and make my initial enquiry as clear as I could. I thought that the second example...

Hi Mynda, I think I have worked out how to do what I need. I have used Table.SelectRows and Text.Contains functions. I added a custom column wit...

Hi Mynda, That would work for the Region as in my example file the region is always at the start of the text string. However in the full live data ...