Forum

Try this Mcode let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], CheckColors = Table.AddColumn(Source, "Custom", each if[Colors]="Gre...

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = Table.Group(Source, {"District"}, {{"Data", each _, type table [Dist...

How about loading a sample workbook showing what you have and then mock up what you expect the results to look like. We can then analyze and provide ...

if Text.StartsWith([Our Ref_1],{0..9}) then [Our Ref_1] else null))) try this

Have you looked at this tutorial?

You will need to unprotect them either manually or with VBA. Then once you have refreshed the query, then protect either manually or with VBA

crossposted: Please read:

Can be done using Pivot Table and calculating the differences year over year. See the attached

crossposted:

Will this presentation work for you. I did this in Power Pivot and the link to show you how I did this follows.

Thank you both. I now have it working with both solutions. Just so you know, I was working off one of Phil's Blogs as an example. Good on both of...

@Catalin. Tried your suggestion but it did not compute. PQ did not accept the line of Mcode. Did not throw an error, but did post some gibberish in...

Check your connections and see if you have Excel refresh the query upon opening. If so, you can turn it off if you don't need it to refresh.