This is a fun tutorial where we will learn how to calculate average of the highest values that might be spread across different time periods. A good example is figuring out what would be a good proxy for the highest temperature for IL in July. If we simply take one reading for the highest day … Continue reading Tutorial: How to Calculate an Average of the Best using AVERAGEX() and ADDCOLUMNS() Functions

This is a fun little tutorial that will give you another chance to practice you CALCULATE() and FILTER() functions skills. Running totals are a common problem that we have to deal with. To illustrate this problem, I created a sales dataset for innovation products. In our example, after the product reaches $1m in global sales … Continue reading Getting Better at DAX: Having Fun with Running Totals

This is a fun video in which we try to solve an interesting DAX puzzle while learning how to use TREATAS() DAX function. As a bonus I also show you how to debug variables that house a table inside. For that I do a bit of a tutorial on CANCATINATEX() function. The data set is … Continue reading Getting Better at DAX: Understanding TREATAS() Function

I know these are not the most politically correct words; however, we cannot build a real Income Statement in Power BI the way we can in Excel. The best we can do is put together something that looks like an Income Statement and hope that our CFO will accept it, knowing very well, that there … Continue reading How to Fake an Income Statement in Power BI (Tutorial)