Forum

Use IFERROR: =IFERROR(GETPIVOTDATA(....),0)

You also don't need separate loops (especially as one of them is a repeat of a previous one): Sub Copyfrom_Workbook_Another() Dim Wb1, Wb2 As ...

Sure - you can do something like this: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], RenamedColumns = Table.TransformColumnN...

You could do something like this: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Duplicated Column" = Table.DuplicateColumn...

If you want to test if the table is just a range on a worksheet rather than queried from elsewhere, you can use something like: If Activecell.ListO...

Are you sure you're using the same fields in the matrix in PowerBI as in your PP pivot table? Can't really tell much from those pictures.

You could do something simple like this then: let Source = Excel.CurrentWorkbook(){[Name="Matchups"]}[Content], #"Changed Type" = Table.Transf...

No problem - must have been gremlins. 😉

The syntax you posted is fine - where is the debugger showing the error point?

Hi, A couple of questions if I may: Does it actually matter what the group numbers are, as long as the grouping works? Also, do you actually ...

Please remember the forum rules on cross-posting and provide the links in future. Thanks. stackoverflow.com/questions/75895739/if-and-max-form...

I didn't say Table.ReplaceValue I said Replacer.ReplaceValue instead of Replacer.ReplaceText, which you are using now 😉 #"Step 1" = Table.Re...

Your match function will stop at the first match it finds, so you need to make sure your table has the most specific items first - eg January February...

Remove the #Changed Type step - it refers to all the columns.

You haven't posted the error, or the full current code. SaveCopyAs will not close the current workbook but it will leave it in the same state it was i...