Very happy to see that my Power Query Management Studio isn’t just perceived nerdy but useful as well 🙂 Thanks to Dusty for his nice review.
So let’s push it a bit further and add some MDX functions to it that cannot be done by DMVs:
- get a list of all unique fields used in a specific MDX query
- translate your code to a different cube using a simple field-translation table
