This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation.
Read more

Course calendar
video courses
  DAX Patterns collection
  Intro to Data Modeling Free
  Data Modeling for Power BI
  Power BI Dashboard Design
  Introducing DAX Free
  Mastering DAX 2
  Optimizing DAX
  SSAS Tabular
  Power Pivot
Classroom courses
Check out the latest updates on our training page.


Latest videos

DAX Patterns


Latest news
• Analyze in Excel for Power BI Desktop 1.1.2
The latest version of Analyze in Excel for Power BI Desktop no longer creates an ODC file. This reduces the friction required to open a PivotTable over the data of your Power BI Desktop file. If you missed this new tool in August, this is your chance to learn and install it. Otherwise, check you have the latest version and send us your feedback if you run into any issue!
Aug 26, 2020 · SQLBI
• The hard truth in numbers
Marco Russo wrote a blog post about data-driven decisions. It is hard to accept numbers that we do not like, but this seems to also happen to data professionals. Marco's recent survey about features in External Tools or in Power BI is an example of that.
Aug 22, 2020 · Marco Russo
• Power BI data protection updates
Recently, Microsoft introduced a feature to declare the sensitivity of data in Power BI datasets. This information is now reflected in Power BI reports and in Excel PivotTables connected to Power BI datasets.
Aug 18, 2020 · Microsoft
• On-premises data gateway August 2020 update is now available
It is always a good idea to keep your on-premises data gateway up to date!
Aug 21, 2020 · Microsoft
• DAX Studio and Tabular Editor – better together
Darren describes in several blog posts how to improve DAX Studio by taking advantage of Tabular Editor features. You can generate a DAX query that computes all the DAX measures in a model by using a DMV query in DAX Studio, or you can do the same thing with a script in Tabular Editor. The latter offers better flexibility and control.
Aug 26, 2020 · Darren Gosbell
• Displaying routes on a map in Power BI
Chris Webb describes how to create routes on a map in Power BI through the Icon Map custom visual. In doing so, he also uses techniques shown in a previous post, Power Query geography and geometry functions in Power BI and Excel. If you are displaying data on maps, these posts are a must-read.
Aug 23, 2020 · Chris Webb
• How to block the creation of a classic workspace in when a new MS Team is created
There is a new tenant setting for Power BI to block classic workspace creation. This way, creating a new team in Microsoft Teams does not create an empty unused workspace in Power BI. A feature to disable a feature, great!
Aug 18, 2020 · Nick Edwards
• Tabular Editor 2.12.1
The latest version of Tabular Editor (2.12.1) offers improvements in scripting, better support for command-line execution, updates to latest libraries, and many bug fixes. Now that Tabular Editor is available as an External Tool in Power BI, you have no excuses for ignoring it!
Aug 28, 2020 · Daniel Otykier
• What Power BI fonts may help report viewers with dyslexia?
Being strategic about the fonts you choose can make a small difference for many people, and a huge difference for people with dyslexia. Being aware of that is key to create more accessible reports!
Aug 25, 2020 · David Eldersveld
• Fun with Power BI and color math
Talking about accessibility means describing how to make a report easier to understand for everyone. Choosing the right color contrast ratio is one of the things we can do to make a report clearer, and Meagan Longoria shows how a Power BI report can help you make the right choice for your own report!
Aug 20, 2020 · Meagan Longoria