Last seen: Jul 7, 2026
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 ...
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 ...
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...
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...
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...
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 ...
Could you upload an example file? Than we don't have to guess and create something from scratch.
Better late than never. Please see if the attached file accomplishes what you need.
Please upload a file (exclude any confidential information) so that we can see what exactly you are dealing with.
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...
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...
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...
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...
I looked at your query and it seems that you are creating new columns "Level1", "Level2" etc based on the 'Stufe' columns where you replaced "X" with ...
That's odd. Since Column E in the 2023 tab is formatted as Number, then loading the table from PQ where the Plot column data type is 'Whole Number' sh...