Power BI & PowerApps: Two Tradeoffs You Face as You Embed PowerApps into Power BI Report

If you decided to embed a PowerApp into your Power BI report, then you got some hard choices to make. Specifically, you have to decide what is more important to you: Having to be able to control the size and the look and feel of your PowerApp, or Being able to refresh the Power BI … Continue reading Power BI & PowerApps: Two Tradeoffs You Face as You Embed PowerApps into Power BI Report

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 & DAX Tutorial: How to Implement Allocations

If you are in FP&A and trying to understand profitability of your products/business units, you have had to face a challenge of allocating certain corporate/HQ expenses. In this tutorial I go over the steps of implementing allocations in Power BI: Desktop file location: https://bit.ly/3dOUTNV The calculations below are used in the tutorial: Rent = CALCULATE ( SUM ( GL[Amount] ), KEEPFILTERS ( GL[Account] = "Rent" ) ) Amount with Allocation = … Continue reading Power BI & DAX Tutorial: How to Implement Allocations

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