Last seen: Jul 3, 2025
If you look at the example i sent, Source table is using Table.Buffer, I did not saw it in your query. The table that needs to be sent to FilterTable ...
Move this code in a new query, named FilterTable: (tbl as table, Person as text, Company as text, EntryDate as datetime)=> let Filtered = Ta...
glad to hear you managed to make it work. The function FilterTable can be moved as an external function, if needed.
Close, The result table can be read in the same query that reads the web: let Quelle = Web.Page(Web.Contents("https://www.ariva.de/tecdax")), D...
Hi Adam, try this query: let Source = Table.Buffer(Excel.CurrentWorkbook(){[Name="AdamS"]}[Content]), ChangedType = Table.TransformColumnTyp...
If you load the results to a worksheet, you can take the results table into a new query (this will be your archive, the oldest results), then combine ...
Data seems to be in pairs, so if data is consistent , the offset should work. There can be other ways, but more complicated: create a function that...
Hi Peter, While you have the numeric quarters, you can add a column with a simple formula: =if [Quarter]<3 then "H1" else "H2" Now, you can t...
Yes, there is an easy way in fact. Add 2 index columns: one starting from 0 and the other starting from 1. Merge the query with itself, with ind...
Can you clarify things? What type of file are we talking about? Can't say from your description if it's excel, text word or any other type. Best...
in Power BI, you can easily export to a csv or xlsx, you cannot do that in excel Power Query. If you install R language support for Power BI , you ...
Use the Go To Error button that shows up in Transform sample2 query. Will highlight [id="Page002"] Even you are filtering, automatic transformation...
I suggest removing #(lf) from the query, it's not necessary. Best is to test the query text into sql server directly in the database, before using it ...
Hi John, you should separate the queries for page 1 and 2. For page 2, catch the error with: try...otherwise . Should be something like: try GetDat...