![]() Set the format string on the new measure: "SUM(" + c.DaxObjectFullName + ")", // DAX expression Tabular Editor offers you an elegant way to automate this task, as you can choose multiple columns and create desired measures in one single run! // Creates a SUM measure for every currently selected column and hide the column. However, once your model becomes more complex, and you need to build multiple similar, but still different measures, the task of creating explicit measures becomes tedious. And, it’s not an issue when you are dealing with a simple data model and there is no need to create many measures. ![]() In one of the previous articles, I’ve explained why you should always create explicit instead of implicit measures. How cool is that! #2 Creating measures from selected columns ![]() I can execute a single command to remove default summarization from ALL the columns within my data model!.Now, it may come quite handy when you have “real” numeric columns, but what if you have IDs as foreign keys to your dimension tables – a typical example would be the Date dimension table: One of them is the fact that whenever you have a numeric column, Power BI will automatically apply summarization on top of it, as a default. But, there are some default settings that annoy me. In the remaining part of this article, I will share my top 6 features in TE 3, and why I believe that without using this tool, my Power BI development would be less efficient.įeatures are not sorted by order of their importance, I’ve just listed them without any specific preference… #1 Advanced Scripting I’m standing firmly behind the statement in the header above. Tabular Editor 3 – The best tool for Power BI development! However, beginning this month, we finally got a new version of the favorite tool of many Power BI developers – Tabular Editor 3! This version is not free anymore (you can find licensing options here), but please continue reading, as I assure you that getting the license for TE 3 will be one of your best investments if you are working with Power BI on a daily basis. At the moment of writing, the latest version is 2.16.1, and Daniel promised to provide support for the free version in the future too. Up until recently, Tabular Editor was completely free to use, and it can still be downloaded for free here. By definition, TE is a lightweight editor for SSAS Tabular Models (so, it can be used also out of the Power BI scope), that enables you to build, maintain and manage Tabular Models. Beginning this year, Microsoft’s announcement on the general availability of Read/Write XMLA endpoints, widely opened the door to many external tools intended to provide additional modeling capabilities supported by the Analysis Services engine, but not natively supported in Power BI Desktop.Īmong many great tools, Tabular Editor, created by Daniel Otykier, is probably the most popular one, together with DAX Studio.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |