I knew this moment would come, but I did not know when. We are now able to have a smart measure that can be displayed as any valid number format on our chart, $$ or %, or even whole dollars All it took was for me to raise a bug with Microsoft about the formatting … Continue reading Finally!!! We Can Now Format The Same Measure as % OR $ on the Same Trend Chart (calculation groups bug is fixed!)
Month: July 2020
Improve Slice and Dice End User Experience for Tables with Multiple Dates (tutorial)
Slice and Dice experience on a table with multiple dates can be a little frustrating. If I have two date tables connected to my two date columns in the transaction table (so if I have a list of projects, Project Start Date and Project End Date), and if I create two filters at the same … Continue reading Improve Slice and Dice End User Experience for Tables with Multiple Dates (tutorial)
How to Show Today on a Trend Chart (quick DAX Tutorial)
Let's say that you have a trend chart, and let's say that you would like to make it easier for a user to see where today's date is on that chart. If that sounds like a useful feature to have, then give this short video a listen and download all the materials here. https://youtu.be/pqVbdhMe53U
Power BI DAX Tutorial: How to PIVOT Data Using DAX (using RANK.EQ function)
Little known fact, I used to box, and boxed a lot… Unfortunately, it did little to help me with my public speaking as you will definitely be able to see from this video where I constantly say UNPIVOT instead of PIVOT. My apologies, hopefully, you will be able to enjoy the video anyway as the … Continue reading Power BI DAX Tutorial: How to PIVOT Data Using DAX (using RANK.EQ function)
DAX Tutorial: Average Days Between Orders
How often does our customer place an order with us? This is a common business scenario, therefore, I decided to cover it in another DAX Tutorial. There are two ways this question can be posed: How many days on average does it take the customer to place another order? How often does the customer order … Continue reading DAX Tutorial: Average Days Between Orders
DAX Tutorial: How to Count Things That Did Not Happen?
We already know how to analyze things that happened because for every occurrence we have a record in the fact table that tracks that event. What do we do to analyze things that did not happen? For example, what if I am looking at my sales data and trying to figure out what products are … Continue reading DAX Tutorial: How to Count Things That Did Not Happen?
Tutorial: How to Calculate an Average of the Best using AVERAGEX() and ADDCOLUMNS() Functions
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
Getting Better at DAX: Having Fun with Running Totals
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
Getting Better at DAX: Understanding TREATAS() Function
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
How to Stay Current with Power BI Updates and Roadmap
In this video I cover several official sources from Microsoft for staying current with Power BI updates and road map. The important links are below. https://youtu.be/YVcATKT0Ygs Roadmap: 2020 Release Wave 1 Plan: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/ 2020 Release Wave 2 Plan: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/ PDFs: Wave 1: https://go.microsoft.com/fwlink/?linkid=2116925 Wave 2: https://go.microsoft.com/fwlink/?linkid=2134934 Ideas: https://ideas.powerbi.com/ Power BI Blog: https://powerbi.microsoft.com/en-us/blog/