For today’s tutorial, I’m going to show how you can automate the process of sorting one column by another column inside Power BI and SSAS or SQL server analysis services. You can watch the full video of this tutorial at the bottom of this blog. In this example, we have the Dates table with several
In this tutorial, you’ll learn how to create measures inside the Tabular Editor 3. You’ll also learn how to load the measures into the Power BI Desktop and create visualizations. The IntelliSense feature of the Tabular Editor will also be shown and discussed. Create Measures To create a measure, right-click on a table and select
This tutorial will discuss about a productivity tool inside the Power BI Desktop called Tabular Editor 3. You’ll learn about the tabs, menus, and panes inside the editor which you can use for your data report. You’ll also learn how to personalize the editor to your preference. Opening Tabular Editor 3 There are multiple ways
This tutorial will talk about the Diagram View in Tabular Editor 3. You’ll learn how to maximize this tool to create your data model in an efficient manner. You’ll also learn how this option can improve your data development skills in Power BI. Opening The Diagram View To get the diagram view of a data
In this tutorial, you’ll learn about the Preview Data option in the Tabular Editor. You’ll also learn how to efficiently use it to obtain certain data from large tables and reference it when writing scripts, DAX codes, or measures. Opening Preview Data In The Tabular Editor If you want to view the data of a
