Forum

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 ...

Hi Mynda, I have had a look at the options in the data model and I can't see where you would add the sort order. Can you help? Thanks Ba...

Hi Anders, Thanks for the reply. Unfortunately I don't control the report that the pivot is in and therefore can't add an index to it. I am more in...