Tag: Supporting Table

Advanced DAX Functions: Calculating Profit Contribution

In this blog, I’ll be discussing some more advanced DAX functions to demonstrate what’s possible in Power BI. This tutorial will teach you how to visualize the profit contribution of different client tiers using advanced DAX functions. Calculating Total Profits I’m going to start by creating a new measure and renaming it as Total Costs.

Continue reading

Power BI Dynamic Visuals Using SWITCH TRUE Logic – Visualization Technique

One of the most common concerns I see in the Enterprise DNA Support Forum relates to creating dynamic visuals. In this blog, I’ll focus my discussion on multi-measure Power BI dynamic visuals. I have a tutorial about this topic, which I’d like to highlight in this article.  The tutorial will show you how to work and present your results in a dynamic way and how you can change

Continue reading

Power BI Grouping Technique: Aged Trial Balance Using DAX

We’re going to explore a really unique Power BI grouping or segmentation example in this tutorial. We’ll create an aged trial balance grouping inside Power BI. This technique involves re-using many of the grouping and segmentation patterns that we already learned. Utilizing Power BI grouping patterns for this unique example is no different. The idea

Continue reading

Power BI Financial Reporting: Allocating Results To Templates At Every Single Row

Here I want to showcase a unique idea around financial reporting, which is allocating results to predetermine table templates inside Power BI. After spending quite some time working out how to create these custom templates, I’ve finally devised a strategy around Power BI development. This strategy enables us to not only create these templates, but

Continue reading

Advanced Analytics In Power BI: Threshold Triggers Using DAX

In this tutorial, I run through an advanced analytics technique in Power BI called Threshold Triggers. With this analytical concept in Power BI, you can set certain thresholds or certain trigger points via a supporting table in your data model. Once you’ve added this supporting table and it’s inputs, you can then run logic through

Continue reading