Last seen: Jun 11, 2026
The GETPIVOTDATA formula works if you use the Hours Formula field in the pivot. I'm not really sure what the issue was with that?
There are several ways you could achieve it. For instance, you could create one query on the table that filters for topology, then merge that query wi...
How would you distinguish a header row from a data row specifically?
You could also put those values into a column of cells and use that as criteria in an advanced filter.
It's expecting a list of items to remove so use {"Col3"} instead of just "Col3": let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content...
The prior step works fine for me (after creating an appropriate source file for the state list). For a direct in-place replacement, you could ...
Shouldn't the last step read something like: = Table.AddColumn(#"Added Custom", "Address2", each Text.Replace([Address], [States], " ")) ...
There are probably simpler solutions, but you could get a list of the column names, remove the last one (the new column you added) and then combine th...
Make sure the Zip field loads as text, then you can use something like: = Table.AddColumn(#"Changed Type", "CleanZip", each if Text.Length([Address...
I'd suspect the problem lies elsewhere (in the code you didn't post) since I can't see how you'd get a file count for a non-existent folder.
They are visible, just not active - you still have the front sheet selected which is entirely grey. Also, the sheet tabs have been hidden so there is ...
What is the formula?
The Activate code in the form protects the workbook. That means that you can't then change the visibility of any sheet unless you unprotect the workbo...
You've used a colon instead of a semicolon in the name definition - it should read: =$AP$6:index($6:$6;counta($6:$6)+1))
ADDRESS returns text, not a range reference, so you'd need to use INDIRECT: =AP6:INDIRECT(address(6;counta(AP6:BJ6))) or perhaps just:...