NEW ARTICLE
The LOOKUPVALUE function retrieves values from a table in a simple way, but it involves a hidden level of complexity. Four weeks ago we published an introduction to LOOKUPVALUE. This new article provides full coverage of the internals of LOOKUPVALUE, along with several performance considerations.
Read more

 

NEW POST
The consumption experience following the introduction of calculation groups needs to be improved in Power BI. This blog post explains the need for a feature to enable the selection of arbitrary combinations of measures and other table/column items in visuals.
Read more
 

LEARNING
Course calendar
video courses
  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
We are rescheduling courses as required by the ongoing situation, and in the meantime we have made sure to keep supporting our students on their learning path.
Check out the latest updates on our training page.
Mastering DAX Video Course

 

SQLBI YOUTUBE CHANNEL
Latest videos


 

BI-WEEKLY NEWS DIGEST
Latest news
• External tools to document your Power BI model
Everybody wants documentation, nobody wants to write it. So why not use Power BI as an external tool to document a Power BI model, thanks to a Power Shell script? Marc shared this with all of us!
Jul 28, 2020 · Marc Lelijveld
• Python as an External Tool for Power BI Desktop
The External Tools ribbon could become the busiest one in Power BI if you install all the tools coming out. This example shows how to integrate Python so that in a separate window, you can access data in Power BI and export or visualize them in different ways. The article is split into different parts, the link points to the first part.
Jul 20, 2020 · David Eldersveld
• DAX Studio 2.12.1
We finally have DAX Studio with a code-signing certificate that removes the annoying security warning at download and installation time. Plus, additional new features and many bug fixes. You can finally forward this link to your network administrators without scaring them!
Aug 3, 2020 · Darren Gosbell
• Tabular Editor 2.11.7
Several fixes and small new features in this update of Tabular Editor, which is now largely adopted thanks to External Tools in Power BI. The frequency of updates of this tool - and the speed in addressing bugs - is amazing.
Jul 30, 2020 · Daniel Otykier
• How to force your visual to always be on top?
There are many ways to control the z-order of visuals in Power BI and to "manage" the overlap between visuals. This interesting blog post explores the pros and cons of three possible solutions.
Jun 29, 2020 · Maksym Myronenko
• Gradient legends in Power BI
One of the many new features introduced by Power BI Desktop July 2020 is the gradient legend that can be applied to a bar chart. This post describes in detail how to use this feature and the results you can obtain.
Jul 25, 2020 · Laura Graham-Brown
• Adding tooltips to column headers in the Power Query editor in Power BI and Excel
Did you know you can make tooltips appear when you hover over column headers in a table in the Power Query editor in either Power BI Desktop or Excel? It's all done with M metadata...
Jul 19, 2020 · Chris Webb
• Doing Power BI the right way: Future-proofing Power BI solutions
In this blog post that may be the first of a very long series, Paul shares his thoughts about planning a Power BI solution correctly. While Power BI can initially be seen as a simple tool to create quick reports, it can also be a pillar of enterprise-grade solutions, which require some planning if you don't want to rebuild everything from scratch in the middle of your project.
Jul 29, 2020 · Paul Turley

DAX Formatter