Forum

Hi Aye, No idea what you're doing there. Why is filteredID a blank query? Also, what is "List.Count(List.Distinct([FilteredID][Category])" for? ...

Take a look at the previous step, just above Filled Up step. There should be a column named "ticket_doc", the next step query says it cannot find that...

Hi Alison, You have added fields from Banding table (Label) into the pivot table, but there is no relationship between Banding and Orders Intake ta...

Hi baxbax, you can use the following function, that replicates the nearest match lookup: (Parameter)=> let Source = Excel.CurrentWorkbook...

instead of source = Data use: Source=Table.Buffer(Data) Then you will add your custom column.

That's what the example I prepared is doing: takes a 1 column list of dates, then combines them into a "From:...To:..." dates range.

Hi Allison, Noticed that you have a list created by a query, Report Date. Is this dates list you want to append as a new column to your data table?...

You can use Table.Buffer(previousStepName) before adding the new column, this will load the data table to memory instead of querying again and again t...

Hi Aye, Please take anther look into the attached file. The function does not need to perform so many steps, use a data query that takes source ...

Descriptions needs to be combined into a single line of text in this case. This can be done fairly easy, by filling down the ticket doc ID to all r...

Hi Todd, Before each group, there is a description like: " There is an issue with the back side fuse post_text box that is misbehaving " ...

Hi Sylvain, You can prove that without much pain... You can calculate the difference between all start-end dates, the total should be equal to the ...

Hi, You can add a blank query (From Other Sources-Blank Query), then open the Advanced editor and replace what's in there with the code I sent in t...

There is not much about it, it's just your data table imported into query, then filtered by ID. If you remove the first line, it will be just a normal...

Hi Todd, Can you please upload a sample text file as it is exported from that database? Pasted data in browser will alter the data, the browser is ...