How To Sort Columns In Power BI and SSAS Using Tabular Editor 3 and C#

For today’s tutorial, Antriksh is going to 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 *****

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #TabularEditor

[remib]

Good video and explanation of C# code you are providing is great.
I can see how we can automate the definition of column to be sorted such has retrieving all columns with a particular word and checking if there is a corresponding column without the word, you used "Number but it could be "Sort" for example
That might be less flexible on edge case such as Calendar Year and Calendar Year Number for hiding or not column but with extra test it could be handled.

[mehdihammadi]

Thanks for sharing? I love automating things and this tutorial is very informative in many ways.

[wayneedmondson]

Interesting topic! Thanks for sharing. Thumbs up!!