Havens Consulting
Video by: Reid Havens
Learn how to leverage model tables/columns, and relationships to simplify your DAX code for your Power BI datasets (models), leading to simpler measures, and potentially more efficient (faster) calculations and visual queries. Tune in to learn more!
Video by: Reid Havens
Learn how to leverage C# scripts in Tabular Editor 2 or 3 to create instant Time Intelligence DAX measures off any existing calculations already in your model. This is a huge time savor for applying common date pattern calculations instantly with just a couple clicks in Tabular Editor.
Format All Measures C# Tabular Editor
Benoit Fedit's TE Script
Bernat Agullo's TE Script
Video by: Reid Havens
Learn how to add Dynamic Format Strings for individual [DAX] measures in Power BI! This technique doesn’t require calculation groups or Tabular Editor either, and can be done entirely inside of Power BI desktop.
Side note, if you aren’t using Tabular Editor as a model developer you should be. It’s a fantastic tool for any intermediate to advanced modeling scenarios, and the only way to add calculation groups (today).
Dynamic Format Strings in DAX
Kane Snyder’s Linkedin Post
Tabular Editor
Video by: Reid Havens
When creating datasets with build permissions (shared datasets), many of us know to hide fields from the data pane. But did you know you can also "hide" measures from the intellisense list in DAX? In this video learn how to use tabular to configure a table property to hide any measures inside of that table, from any DAX intellisense when writing measures. Further increasing usability when creating shared datasets in the Power BI service!
PLEASE NOTE this is not (officially supported) by Microsoft. But is a relatively safe setting to modify. Just be aware Microsoft doesn't provide support for this. More info below at the tabular editor link
Data Goblin Report Layer Article
Tabular Editor Private Setting
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
