Tag: Expanded Table

Expanded Tables In Power BI

By Antriksh Sharma on March 18, 2022March 21, 2022

In this tutorial, we are going to take a look at a very specific scenario that I’m sure all of you have already encountered while working with DAX – the expanded table. Expanded tables can mess up your calculation if you don’t know how they actually work. You can watch the full video of this

Posted in: ALL Function, CALCULATE function, DAX Studio, Expanded Table, Power BI, RELATED, SAMEPERIODLASTYEAR

Business Intelligence Data Modeling DAX Power BI Time Intelligence

Counting Customers Over Time Using DISTINCTCOUNT In Power BI

By Sam McKay, CFA on December 27, 2019May 16, 2022

In this blog post, I’m going to run through how you can calculate how many customers you sell to through time using a few functions such as DISTINCTCOUNT inside of Power BI. There are actually a few ways you can calculate it, which is why I wanted to create a short tutorial on it to

Posted in: Advanced DAX, Data Modeling, DISTINCTCOUNT function, Expanded Table, Mastering DAX Calculations, Power BI Customer Count, Scenario Analysis