Forum

Hi Blanka, It is more efficient for Excel if you add your calculated columns in Power Query as that avoids having a load of DAX formulas in your Po...

Hi Gavin, Thanks for spotting those errors. I've fixed them and uploaded the revised workbook. It's probably quicker and easier for you just to mak...

Glad you got it sorted out! Thanks for sharing the solution.

Hi Aye, No file attached. Mynda

Hi Stephen, Thanks for confirming those points. I found this thread that suggests clearing the SSL state in IE. IE is used by Power Query to get...

You only get presented with this option the first time you ever access the web page. See image attached. Typically a web connection is anonymou...

Ok, but did you have a go at rearranging the PivotTable yourself to get your desired result? If you got stuck, please upload your file again so I can ...

Hi Alex, Welcome to our forum. You can do this with a merge. See file attached. I've done a 'merge as new', but you could replace the tInvoices ...

Hi Enrique, I don't think you can use GETPIVOTDATA on an external Power Pivot model. I know with regular PivotTables the workbook being referenced ...

Hi Stephen, Not sure. Are you able to browse to that web page without a problem? Did you choose 'anonymous' connection type at the dialog after ...

Hi Tykru, Your question isn't clear. How do you tell what the last invoice was? I assumed it's based on date, but it's not clear if this data is fo...

Hi Karen, Power Query is case sensitive, therefore the columns in the file need to have the exact same names, order and number of them as the origi...

Hi Amber, Session 7.09 demonstrates how you can reference another query to generate a dynamic variable. You need to use the same technique to cr...

Hi Stefano, Try this site: If that page doesn't have it, keep searching that site as it is an excellent resource for DAX measures. Mynda

Hi Matt, When I opened your file I saw the cropped image in the camera tool but it quickly fixed itself. I wonder if you have an add-in on your PC ...