Let's say you want to compare time series of two product launches that are six months apart. Plotting data chronologically will not be very user friendly. The best way to do it is to plot them based on number of days from the launch date. This way we can easily see which product grew to … Continue reading Power BI & DAX: How to Compare Timeseries with Different Start Dates
Category: DAX
Demystifying DATESINPERIOD (or How to Calculate N Months Average Excluding the Current Month)
Date functions in Power BI are not always easy. And sometimes they can be a little confusing… And sometimes, a little more than just a little.. For no other reason than pure serendipity, I have decided to record a quick video using a calculation I had to write to implement a four-month average logic that … Continue reading Demystifying DATESINPERIOD (or How to Calculate N Months Average Excluding the Current Month)
Power BI & DAX: Making Sense of CALCULATE() and FILTER() Functions
If you get butterflies in your stomach every time you have to use CALCUATE or FILTER functions in your DAX then stick around, as I will try to give you some tools that will hopefully bring that anxiety to manageable levels. This is not a short video, unfortunately. I could not cut it short because … Continue reading Power BI & DAX: Making Sense of CALCULATE() and FILTER() Functions
Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane
in this video I talk about the fatal flaw of the Power BI's Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch the video and you will find out. https://youtu.be/6HHbPzqhcn8 These are the measures that I have created to … Continue reading Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane
PowerBI & DAX: Three Reasons to Move All Your Measures to the Metrics Table
Metrics tables are great! I argue that all of you measures should be moved into a Metrics table. Don't know what a Metrics table is? Care to know why I think you should move all measures to that table? Please watch the video below and your questions will be answered. My reasons: Makes it easier … Continue reading PowerBI & DAX: Three Reasons to Move All Your Measures to the Metrics Table
Power BI: Getting Better at DAX – Understanding SUMX()
SUMX() is one of my favorite functions, but it can be tricky to understand how it works some times. Hopefully, this video can help you understand this function a little better. https://youtu.be/dY9YniavqMA The points I make in the video: Normally, in DAX we cannot do math using column names for additions and multiplications, however, when … Continue reading Power BI: Getting Better at DAX – Understanding SUMX()
Power BI & DAX Tutorial: Waterfall charts with beginning and end states in 5 minutes
Previously, I talked about what a pain in the neck waterfall charts are in Power BI. I also recorded a video about it here. However, the video can be hard to follow, therefore, I have now recorded a tutorial. You can download the desktop file with all the calculations here: https://bit.ly/2BcVkD5
Power BI & DAX: How to Make Waterfall Charts Work (showing starting and ending values)
If you have tried to use the default Power BI waterfall chart to recreate your PowerPoint variance bridge but got frustrated because you were not able to show from and to values along with your variances, then you are in luck, because in this video I will show you how you can build any variance … Continue reading Power BI & DAX: How to Make Waterfall Charts Work (showing starting and ending values)
Power BI & DAX: How Fast is KEEPFILTERS() Function?
In my first foray in to investigative journalism, I am taking a look at Microsoft's recommendation to use KEEPFILTERS() function where possible to improve performance. (https://docs.microsoft.com/en-us/power-bi/guidance/dax-avoid-avoid-filter-as-filter-argument) I also talk about Microsoft Power BI Guidance – a very good resource for commonsensical Power BI related advice and best practices. (https://docs.microsoft.com/en-us/power-bi/guidance )
Power BI and DAX: Three Reasons to use DAX Variables
There are many reasons to use variables in your DAX code. I decided to make a video about the following three: Readability Caching Performance If you find the video to be helpful, you can find the DAX I used in the video below. Net Price = DIVIDE ( Sales[Gross Sales] - Sales[Rebates] - Sales[Discounts], Sales[Units] ) Net Price (var) = --DIVIDE(Sales[Gross Sales] - Sales[Rebates] - Sales[Discounts],Sales[Units]) VAR netSales = Sales[Gross Sales] - Sales[Rebates] - Sales[Discounts] RETURN DIVIDE ( netSales, Sales[Units] ) Avg Product Price = DIVIDE ( SUMX ( FILTER ( ALL ( Sales ), Sales[Product] = EARLIER ( Sales[Product] ) ), Sales[Gross Sales] - Sales[Discounts] - Sales[Rebates] … Continue reading Power BI and DAX: Three Reasons to use DAX Variables
business intelligist 