Forum

Hi Hitesh, As mentioned, for the Average you need a month count: MonthCount:=VAR _start = STARTOFYEAR( ALL('Date'[Date] )) VAR _end = ENDOFM...

Hi Thomas, Can you prepare an example of the most complex case, with the expected result, indicating which cells are contributing to the result?

You will need a recursive function, there are more nested lists. Here is one (name it CombineList): (Item as any)=> let Text= if Value.Is...

That's how the html table from the web page is formatted. For 15% for example, you have some text and a LIST of 17 items. Not much to do about it, you...

Here is the query: let Source = Excel.CurrentWorkbook(){[Name="Ophalen_Data"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"L...

The step Promote Headers points to Added Custom step, not the Added Difference step, so it ignores the step you added. Change from: = Table.Prom...

One simple trick: After you group the data, demote headers, the button for "Use First Row as Headers" has a dropdown with the opposite action: "Use He...

Hi Alastair, Please provide the math behind the required calculation, and an example with a manual calculation, including what cells are used in the e...

Honestly, I doubt that anyone is following word by word any naming system, takes longer to learn it than learning to code :). What I said is that the ...

Hi Alan, Let's stay on topic please, other dissertations will just make it harder to read by other visitors. There are many things classified as "c...

Hi Jen, Please provide sample files that we can test, we are not wizards to see what you are doing (unfortunately). What do you mean that you ca...

Hi Jen, Using automatic file combiner is not flexible, try the solution from here: A pivot table needs to be refreshed separately than PQ refresh...

Where is the csv name in your url? Not seeing it in any of your posted code. Web.Contents is NOT Folder.Files, in case you want to get multiple csv...

the logical type (True/False) corresponds to the vba Boolean type.

What do you mean? "i could not pass it into VBA result yes?" Do you want to replicate the Power Query engine to run the query text in VBA as a "vir...