Boosting Power BI productivity with Tabular Editor
Tabular Editor is a productivity tool for Power BI and Analysis Services developers, that makes it easier to work with complex models with many tables, measures, etc. You can use it as an External Tool for Power BI Desktop, to make DAX authoring more productive, run scripts, check best practices, etc. If you're using Power BI Premium, you can migrate all of your data modeling to Tabular Editor, enabling advanced scenarios like data model version control, parallel development and CI/CD. In this session, we'll go over all the features that make Tabular Editor a must for any data model developer. ๐๐๐ง๐ ๐ฎ๐๐ ๐: English ๐๐๐ง๐จ๐๐๐ฃ ๐๐ฝ๐๐๐- ๐๐๐๐ง๐ค๐จ๐ค๐๐ฉ ๐พ๐ค๐ข๐ข๐ช๐ฃ๐๐ฉ๐ฎ: https://bit.ly/3IAg7xT ๐๐๐ฃ๐ ๐๐๐๐ฃ: https://bit.ly/32tGkif ๐๐๐ก๐๐๐ง๐๐ข ๐พ๐๐๐ฃ๐ฃ๐๐ก: https://t.me/PersianPBIUG ๐๐ค๐ช๐๐ช๐๐: https://bit.ly/3hk20RLBuilding Calculation Groups in one click
Calculation groups are great for extracting logic in one central place instead of placing it on each measure. This abstraction means that you might even want to use the same calculation group on different data models, but then you might need to change some parts of the Calculation Items. Tabular Editor C# Scripts are a great way to make this process a breeze and give you super-powers! In this session we'll see some simple calculation groups and the process to create a macro that builds it with some customization on run-time of the script. Speaker Bio: Bernat Agullรณ is a data engineer and Power BI enthusiast based in Barcelona. He is a partner at Esbrina, where he writes his blog www.esbrina-ba.com/blog He's been recently awarded the MVP Data Platform award for his contributions to the community. ๐๐๐ง๐จ๐๐๐ฃ ๐๐ฝ๐๐๐- ๐๐๐๐ง๐ค๐จ๐ค๐๐ฉ ๐พ๐ค๐ข๐ข๐ช๐ฃ๐๐ฉ๐ฎ: https://bit.ly/3IAg7xT ๐๐๐ฃ๐ ๐๐๐๐ฃ: https://bit.ly/32tGkif ๐๐๐ก๐๐๐ง๐๐ข ๐พ๐๐๐ฃ๐ฃ๐๐ก: https://t.me/PersianPBIUG ๐๐ค๐ช๐๐ช๐๐: https://bit.ly/3hk20RL Language: English
Power Up Fabric Development with DAX Studio and Tabular Editor
Do you have a slow Power BI report? This session will equip you with the knowledge to address the issue of slow Power BI reports. Whether you are just starting on your Power BI Journey or an experienced Power BI developer these tools enhance your development and analysis of your data. This session will cover connecting to Power BI Desktop, Power BI Premium Workspaces, and Fabric Workspaces to meet you where you currently are. DAX Studio and Tabular Editor are part of the study guide for the DP-600 exam for Fabric, so this is the perfect time to start learning how to put them to good use. The first tool we will look at is DAX Studio. Its strength is being able to analyze your data separately from Power BI and Fabric. You can use it to quickly gather statistics about multiple semantic models. Has a user reported that one of the reports is running slow? You can use DAX Studio to do DAX performance tuning to make it faster. The second tool is Tabular Editor 2. It gives you the ability to check to see if your models are following best practices. You can make changes to your models whether they are running in Power BI Desktop, Power BI Premium, or Fabric Workspaces. With Tabular Editor you can use scripts to automate changes that if done manually could take days. These are just some of the topics we will cover as we learn how valuable these tools can be. This session will have the greatest benefit to someone new to DAX Studio and Tabular Editor regardless of where you are on your Fabric journey.Oklahoma Power BI & Fabric User Group In-Person Tulsa May 1, 2025
We will meet in person to learn about the latest developments in Microsoft Fabric and Power BI. Topics: Exact speaker TBD but we hope to have someone from Tabular Editor come and show us how their tools can make Power BI Development much easier! Where: Atlas School 15 N Cheyenne Ave Tulsa, OK 74103 When: May 1st, 2025 11AM - 2PM Format: In-person Online option will be added next week, come in person if you are able! Food: Snacks provided, BYOL (bring your own lunch) Link to join online https://teams.microsoft.com/l/meetup-join/19%3ameeting_MDQ4NDRkYzEtYjI4NC00ZmUwLTgyNDgtMzYwNmJjZTExNThl%40thread.v2/0?context=%7b%22Tid%22%3a%2287c82287-dd8c-4a3d-a71a-e1174d7b981c%22%2c%22Oid%22%3a%2258980e9f-457f-45e5-9365-f68c445581fb%22%7d
POWER BI >> HOW TO FORMAT ALL DAX MEASURE AT ONCE
We all write our codes in a proper format so that readability and understanding of codes become easy. While working with POWER BI, we use DAX Expressions to write our measures and calculated columns. We know that formatting is not required in DAX. Itโs normal to see DAX expressions that span over 10 to 20 -lines or more, depending on the complexity and requirements. Sometimes we ignore DAX format as it is time-consuming, and we need to press ALT+ENTER for the new line, which is out of habit for all of us. There is too much ambiguity, and a lack of official specification makes it even harder to comprehend. Whenever I am working with Power BI, I use the following technique to measure it.Refer to a Calculated Measure in Tabular Editor inside a Calculation Item Expression
Hi All, Is there a way to refer to a "Calculated Measure" while we write an expression of a "Calculation Item" in Tabular Editor ? I am trying to build a calculation where I need a "Specific Text" to filter one of the columns in the Dates Table. I already built the the required text and stored as a "Calculated Measure" in the Tabular Editor. Is there a way I can use that as filter argument to another Calculation Item? e.g. In my Calculation Group named "TimeCals" "Calculated Measure A" refers to "XYZ" I need to use the above as follows: Calculate( Selectedmeasure(), Removefilters(DatesTable), DatesTable[Column_A]='TimeCalcs'[Calculated Measure A]
