Forum Discussion
How to combine the rows in multiple worksheets into one master sheet?
LegalSculptor First of all, Excel for Mac doesn't yet support all PQ functionality you may have read about. That said, why would you maintain two separate sheets, wanting to create a third as a master? Put all in one sheet, add a column for the category and work with that.
JimGMac Which "unrestricted" version would that be. I'm on 16.64 (22073100). It certainly has a great deal of PQ but I wouldn't call it "full capabilities". Am I missing out on something?
I think all the functionality, including DAX, are supported in Mac Excel PowerQuery. Are you aware of something missing?
You "think all the functionality, including DAX, are supported in Mac Excel PowerQuery". And yes, I am aware of "something missing" and surprised that you are not.
But let me begin by saying I'm extremely happy that PQ finally came to the Mac not too long ago. Though, it is still for Insiders Beta Channel only, as far as I know.
To mention just a few differences, you can't connect to a web-site or all files in a folder. You can't directly connect to a table or range in the current workbook. You can't choose to have a connection only query and change it later. All queries load to an Excel table (by default) which you can then remove, of course. But you need to go back to the query editor, duplicate the query and close and load again, if you change your mind. Another major feature that is missing, though I trust it will be coming soon, is IntelliSense. In the PC version, PQ helps you complete M-code as you start writing a piece of code. Suggesting functions to use with instructions on how to use them. An invaluable tool, in my opinion. Without it, writing M-code from scratch is extremely challenging. Especially, for Mac users who are totally new to PQ.
And then, when it comes to DAX, that's part of PowerPivot / Data Model, which is not supported by Excel for the Mac (yet).