In our past video, Brian showed how to automatically kill unused columns and measures in Power BI. Now, he’ll demonstrate some cool time-saving techniques on how you can create and organize dozens of measures at once, while also setting format strings and turning off aggregations. 

*****Video Details*****
00:00 Introduction
01:04 Data model
01:50 C# script
02:18 Fact table
03:24 Measures table
04:00 Metadata Mechanic Pro

*****Related Links*****

Tabular Editor 3:
https://tabulareditor.com/

Tabular Editor 2: (Free)
https://github.com/TabularEditor/TabularEditor
Metadata Mechanic Pro (part of Enterprise DNA Power Tools Suite)
https://www.enterprisedna.co/tech/power-tools/

Metadata Mechanic (Free)
https://github.com/gdeckler/MicrosoftHatesGregsQuickMeasures
GitHub Gist Bulk Measure Creation Script
https://gist.github.com/bjulius/8e71fde3e82574d278b9b06093583905

GitHub Gist Countrows Measure Creation Script (code by Edgar Walther)
https://gist.github.com/bjulius/971d8d386183a48d3c6132986704d7f4

Basics of C# scripting in Tabular Editor/TE3 to automate repetitive tasks:
https://youtu.be/luaI_x0GXuw

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events – www.enterprisedna.co/events

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial