Last seen: Dec 22, 2025
Hi Dave, Calculations and references using row index are slow. If you can prepare a sample of your data and query, and explain what you are tryi...
Hi Steffen, Use Power query, New Query-From Other Sources-From Sharepoint List. You will be able to login after you provide the user and pass after...
Hi, All you can do is to increase the timeout value: Source = Web.Page(Web.Contents("http://edge.pse.com.ph/disclosureData/dividends_and_rights_...
Hi Dave, Use Table.Buffer to speedup: #"Added Index" = Table.Buffer(Table.AddIndexColumn(#"Removed Columns", "Index", 1, 1)), You can also op...
Indeed PQ is not the right way. Power Pivot is the way to go, PQ will have to combine all worksheets data to pass it to Power Pivot. There you can set...
Hi Muhammad, It can be done, but as Mynda said, it's best to do it in Power Pivot, because Power Query is not as fast. Here is a query you can t...
Hi Harry, try to build test measures and display them in pivot. For example: Test1:=MAX ( 'Date Table'[Year] ) Test2:=CALCULATE ( MIN ( 'D...
Hi Cindy, When you import from a folder that might have some files open, it's a good idea to filter out the temporary files that are created by exc...
Can you attach a screenshot of your pivot table with the wrong count displayed?
Hi, Don't expect to see the correct values in Power Pivot editor. The measures should be designed to calculate the correct values in a pivot tab...
Hi Robert, The name ReplacementList was not recognized where? In the sample file I sent, if you read the query, you will see it, open the advanced ...
It's not impossible, but keep in mind that if you don't find an easy solution, most likely your data structure is not ideal and that usually leads to ...
Can you attach the file again? can't download.
Hi Rita, Indeed, the key is ALLSELECTED. First, calculate the previous row index, based on selected data: PreviousRowIndex = CALCULATE(MAX('S...
Here is it, i just did what I already said: added an index column, then a custom column with the formula provided. Load the query as a connection o...