When you’re optimizing your data model and your DAX for Power BI, it helps to remember that there are two engines running behind the scenes — the formula engine and the storage engine. These two engines work together to return the results needed back to the user. They provide the results set in the form
This tutorial will discuss how to create a calculated table and column in the Tabular Editor. You’ll learn how to pull out and summarize tables and columns using DAX functions. You’ll also understand why Tabular Editor is better at creating calculated tables and columns than Power BI Desktop. Creating A Calculated Column To create a
Over the last few months, I presented several tutorials, showcasing best practices for Power BI report development for each of the four pillars of Power BI. In this blog, I wanted to take this opportunity to present my personal top 10 list. You may watch the full video of this tutorial at the bottom of
This tutorial will discuss about the two DAX Query Plans in Power BI. Query plans affect the DAX’s performance in generating valuable data. They also help in optimizing DAX codes that make your report more compelling. These are the two query plans that are generated by the formula engine: Logical Query Plan Physical Query Plan
I want to spend some time today talking about tables in Power BI. We run into tables all the time with every problem, but we don’t really spend a lot of time thinking about them alone. You can watch the full video of this tutorial at the bottom of this blog. There was a post
