Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

How To Automate Sorting Columns Inside Power BI Using Tabular Editor

Posted on by Annie D

For today’s tutorial, Antriksh is going show how you can automate the process of sorting one column by another column inside Power BI or SQL server analysis services.

***** Video Details *****
00:00 Introduction
00:25 Dates table
02:50 Visual studio
03:20 Set reference to a library
04:08 Creating a server object
07:40 Declaring variables
09:33 List of tables
11:45 Initiate a for loop
15:22 Using Tabular Editor

***** Related Links *****
Using Visual Studio Code with Power BI – https://dax.tips/2020/07/09/using-visual-studio-code-with-power-bi/

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #TabularEditor

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

Enterprise DNAMon, January 10, 2022 11:21pm