Analyst in Action

Tabular Editor (TE), I have heard this name before. Yes, you probably had it if you work closely with Power BI, then Tabular Editor (TE)is the parallel lead to your PBIX reports. If you haven't explored Tabular Editor (TE), then this blog is for you. With this blog, we will give you all the basic use cases that get ignored in Power BI, but with TE, you can do it seamlessly. There are tons of articles and videos explaining the UI of TE, so we won't be touching it. We will be focusing on different use cases that I normally do with all my Power BI reports. First things first, we will be focusing on the TE version 2 since it's a free tool. You can also opt for version 3, which is a much-improved version than version 2, but I would recommend starting with version 2 and seeing if it suits your needs. Version 3 is a paid version. To download TE Version 2 from this very well known git hub page . Also, do check a small comparison done between the two versions on the TE official webs...

Do you want to save tons of efforts to check if your data model and PBIX file follows the standard best practices and norms? Then this blog is for you. If you are a follower of our channel we already deep dive into the importance of the DAX Studio as an external tool. If you are a beginner I would highly recommend to visit this blog . In today's blog we will check how Tabular Editor can help to optimize the data model.  Best Practice Analyser allows to define or import best practices. It will make sure that we do not violate the best practices while developing a dashboard. Isn't it exciting!! Before we start make sure you already have Tabular Editor version 2.24.1 installed on your system. To install it do visit this link and select the link for windows installer. Once Tabular Editor is installed it will reflect in your PBIX file under external tool. Also, we need to define the standard rules. To do so in your advanced scripting or C# script copy this and save it via Ctrl+S. An...

Let's consider a scenario where you have 10 fields and the request is to create all-the-time intelligence measures such as MTD, 3M, QTD, and YTD. So as a BI developer in total, you need 40 measures. What??? A long list of measures doesn't look good to me. So can we avoid it? Absolutely yes we can avoid it using calculation groups. How does calculation group? It is actually available in an external tool called "Tabular Editor". You can download it from here . Let's get our hands dirty. I am creating a table with Category and Total Sales. From time intelligence I need MTD and YTD. You can do it with simple measures but let's try calculation groups. Under external tools, you can find Tabular Editor. Once you open it you can see the tables you are using. To create a calculation group you can right-click on the table and under create you can find the calculation group or you can do the same with the help of the shortcut (Alt+7). I am naming the group Time Intellige...