The SQL command that does the smart trick: SELECT MEASUREGROUP_NAME as Table_Name, MEASURE_NAME, EXPRESSION as Formula FROM $SYSTEM.MDSCHEMA_MEASURES WHERE MEASURE_AGGREGATOR = 0 ORDER BY MEASUREGROUP_NAME
When you create a measure from the Measures menu on the Power Pivot tab, you get a dialog box which has a field called “description”. I wonder if we can have that field also show in the table we generate with your script. What I’m really trying to do is to change the order my measures appear in the pivot table field list. Right now, they don’t appear in a logical order. As far as I know, the only way to reorder the measures is to delete them and recreate them in the order I want them to appear. So I’m looking for a way to get all the info on the measures so I can just cut and paste when I recreate them.
Fantastic!!! Good job! Saved my life... I'm having problems with excel 2019 and power pivot. My Excel is 32bit and is complaining about lack of memory and this destroyed my connections and one of the queries was lost and I can no longer update or remove it to rebuild. Is there any trick for this? Let me ask you another question, but now about your tip... Is it possible to do the opposite way? Could you give an example like this? Thanks for sharing!!! Itamar C. São Paulo/BR
The SQL command that does the smart trick:
SELECT
MEASUREGROUP_NAME as Table_Name,
MEASURE_NAME,
EXPRESSION as Formula
FROM $SYSTEM.MDSCHEMA_MEASURES
WHERE MEASURE_AGGREGATOR = 0
ORDER BY MEASUREGROUP_NAME
When you create a measure from the Measures menu on the Power Pivot tab, you get a dialog box which has a field called “description”. I wonder if we can have that field also show in the table we generate with your script.
What I’m really trying to do is to change the order my measures appear in the pivot table field list. Right now, they don’t appear in a logical order. As far as I know, the only way to reorder the measures is to delete them and recreate them in the order I want them to appear. So I’m looking for a way to get all the info on the measures so I can just cut and paste when I recreate them.
Fantastic!!! Good job! Saved my life... I'm having problems with excel 2019 and power pivot.
My Excel is 32bit and is complaining about lack of memory and this destroyed my connections and one of the queries was lost and I can no longer update or remove it to rebuild.
Is there any trick for this?
Let me ask you another question, but now about your tip...
Is it possible to do the opposite way?
Could you give an example like this?
Thanks for sharing!!!
Itamar C. São Paulo/BR
This is fantastic! Thank you for this video. Is there any way to also display the description of the formulas?
Hi, thanks for the appreciation! Can you give more details for your question?
awesome. thanks!
Thanks for the appreciation! 🤝