Forum

Glad you got it working and thanks for sharing your solution.

Hi Rebel, Welcome to our forum! There are lots of ways to achieve this, but it's not clear how you want the information presented. You mention l...

Hi Tundul, You're missing the last IFERROR value_if_error argument in the formla that's required before the third closing parenthesis. =IFERROR(...

Hi Pavel, Thanks, much clearer now. See solution attached in query called 'input' on sheet called 'Solution' . Mynda

Hi Charmaine, There wasn't a screenshot attached with your previous comment. It's possible that your .txt document isn't being saved in a prope...

Hi Maree, It could be lots of factors contributing to the resizing e.g. screen resolution, zoom level etc. which are out of your control. I would j...

Thanks for clarifying. I understand what you're trying to do now and it's not something that can be achieved with regular Slicers. You could try us...

Hi Pavel, Thanks for uploading the file. I have a few questions. 1. Is the 'result' sheet the result you managed to get, or the result you're tr...

Hi Allison, Sorry, I should have said that you needed to follow Option 2: Duplicate data and merge. See file attached - PremMember sheet from colum...

Hi Pavel, Can you try uploading the file again, it's not attached. Thanks, Mynda

Hi, Welcome to our forum. I'm a bit confused by the data, probably because there are no dates, so the periods don't have any context of time. If...

Hi Charmaine, I don't have an example I can share, sorry. A model map is a simple table in a separate sheet containing an explanation of how your f...

Hi Charmaine, It sounds like you have an out of date version of Power Query. Can you ask your IT people to update it? In the meantime, if you l...

Hi Jay, If you mean a Dynamics NAV database, then Power Query will push the work back to the database, rather than the PC taking the load. This is ...

Hi Allan, Welcome to our forum. You need to duplicate the query, then group the data to generate the totals you need. Then merge the queries back t...