Forum

Riny van Eekelen
Riny van Eekelen
@riny
Moderator
Member
Joined: Jan 31, 2022
Last seen: Aug 27, 2025
Topics: 0 / Replies: 1296
Reply
RE: Compounding percentage in a pivot table

Glad it worked. Can't tell why my original solution doesn't work for you. Sorry!

2 years ago
Forum
Reply
RE: Compounding percentage in a pivot table

I found a post from 2019 on this very error message. The solution provided there is to wrap the true/false bit in the FILTER function. Added su...

2 years ago
Forum
Reply
RE: Compounding percentage in a pivot table

Looked at your file and get no errors. The Compounded% YTD measure works as expected. Can up upload a screenshot of the error? What Excel version are ...

2 years ago
Forum
Reply
RE: Compounding percentage in a pivot table

When you are done with PQ you can indeed load the table directly into the DM. No need to load it to an Excel table. Just check the box "Add this data ...

2 years ago
Forum
Reply
RE: Two tables - formula needed (link provided to Excel file with examples and questions)

Although Anders mentioned that this could be done with a pivot table, his file included a formula solution with SUMIF. Attached file does include a...

2 years ago
Reply
RE: Compounding percentage in a pivot table

See attached. You can't do that with a regular pivot table. You need Power Pivot / Data Model (DM). I created a few extra columns in the DM and som...

2 years ago
Forum
Reply
RE: How to find rows by checking a column and filling with data when the column matches

Okay, got you now. See attached and let me know in case you get stuck when you apply this technique of merging a table from one step with a table that...

2 years ago
Forum
Reply
RE: Two tables - formula needed (link provided to Excel file with examples and questions)

Could you please clarify? Perhaps a language issue but when you ask "how much notebooks/desktops", do you mean how many (i.e. counting quantities) of ...

2 years ago
Reply
RE: Compounding percentage in a pivot table

Could you upload an example file? Than we don't have to guess and create something from scratch.

2 years ago
Forum
Reply
RE: How to do "Exact match. If none found, return the next larger item" in power query.

Better late than never. Please see if the attached file accomplishes what you need.

2 years ago
Forum
Reply
RE: Filter a Pivot Table field by "Bottom 10 that are greater than 0"

Please upload a file (exclude any confidential information) so that we can see what exactly you are dealing with.

2 years ago
Forum
Reply
RE: How to find rows by checking a column and filling with data when the column matches

For clarity, you have posted your question in the Power Query section, though you mention having looked at the INDEX function. That makes me believe y...

2 years ago
Forum
Reply
RE: Measure to calculate employee turnover

To avoid connection errors upon a Refresh, I copied the data from your DM to an Excel table and used that one to build a new DM from with measures tha...

2 years ago
Forum
Reply
RE: Measure to calculate employee turnover

Could you please upload an Excel file with example data, though with the same structure (table name, column names etc.) So much easier to create a...

2 years ago
Forum
Reply
RE: If/Then Loop with Power Query possible?

Isn't that what I did? Perhaps I just don't understand, but there is no need to loop through all rows. For example in 'Stufe2', index 2 has "Kompon...

2 years ago
Forum
Page 43 / 87