Cumulative Discount or Commission Calculation (Power BI DAX Tutorial)

If you are looking to challenge your DAX skills while trying to figure out how to calculate a Cumulative Discount (or a Cumulative Commission) then this tutorial is for you. https://youtu.be/9hGowlw4YPc A Cumulative discount is calculated by finding the cumulative sales in the specified discount window, and then, using the cumulative sales as the parameter … Continue reading Cumulative Discount or Commission Calculation (Power BI DAX Tutorial)

How to Calculate Revenue and Margin Using Price and Cost History Tables (Power BI DAX Tutorial)

I use Sales data a lot in my tutorials and usually the Sales Fact table will have the following fields in it: DateProductRevenueUnits Along with a bunch of other stuff…. Now, it is actually very common for a company to only provide Units in the Sales Table along with a Price History and/or Cost History … Continue reading How to Calculate Revenue and Margin Using Price and Cost History Tables (Power BI DAX Tutorial)

Data Persuasion: Basic Concepts and Definitions

The older and wiser that I get, the more I realize that our framework of values and motivations is often not so much based on our own experiences and learnings but rather on effectiveness of persuasion of individuals who have taken their time and used their skills to instill our values and to create our motivations. You too can learn how to use data to persuade your audience...

This Is Crazy: ThoughtSpot CEO wants to kill BI and for all dashboards to die

I have heard some CEOs say some crazy things, but this is a special kind of crazy talk that we are dealing with here, folks! In this article, Sudheesh Nair (who is the CEO of ThoughtSpot), gives us his critical view of the BI industry in the context of COVID19 aftermath as he attempts to … Continue reading This Is Crazy: ThoughtSpot CEO wants to kill BI and for all dashboards to die

DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial)

This is the third installment in the series; however, you are not required to read the previous two to follow along. Part I - I frame up the basic concept of analysis in  and suggest a light way easy formula for the PVM calculation Part II - I refine the Mix component of PVM to … Continue reading DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial)

Part II – The Definitive Guide to Price Volume Mix Calculation (PVM) in Power BI – The Perfect Mix

EDIT 2020-12-14: if you are looking for the perfect mathematical formula and the DAX necessary to implement PVM, please go the latest post/video in this series - DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial) In the Part I of this series, I mentioned that I was cutting some corners with my calculation … Continue reading Part II – The Definitive Guide to Price Volume Mix Calculation (PVM) in Power BI – The Perfect Mix

Part I – The Definitive Guide to Price Volume Mix Calculation (PVM) in Power BI – Theory

EDIT 2020-12-14: if you are looking for the perfect mathematical formula and the DAX necessary to implement PVM, please go the latest post/video in this series - DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial) Edit: I recommend that you watch this video first as I cover the important theory in detail and … Continue reading Part I – The Definitive Guide to Price Volume Mix Calculation (PVM) in Power BI – Theory

Build an Ultimate KPI Using a Smart Narrative (Power BI Tutorial)

Until now, I have not been very successful with building a perfect KPI visual that would meet my criteria of being able to show the three critical data points that define a KPI for me: Actual ValueTarget ValueTrend (UP, DOWN, SAME) The out of the box KPI visual has so many limitations that I should … Continue reading Build an Ultimate KPI Using a Smart Narrative (Power BI Tutorial)