Percent profit margins can be used in an organization to measure the profitability of its products or services. It is calculated by dividing the profit by revenue and multiplying by 100. This metric can help data analysts identify which products or services are more profitable and which ones need improvement.

By tracking changes in profit margins over time, analysts can also monitor the effectiveness of cost-cutting measures or pricing strategies. In this video, Sam will show how you can calculate percent profit margins in Power BI using DAX.

*****Video Details*****
00:00 Introduction
00:40 Data model
01:56 Total sales
02:20 Total costs using iterating function
03:14 Total Continue reading “How To Calculate Percent Profit Margins In Power BI [2023 Update]” →

The CALCULATE and TOPN combination is a powerful technique in data analysis that allows users to easily and efficiently discover insights within large datasets. By utilizing this technique, analysts can automate the process of identifying patterns and trends in their data, which historically would have required extensive manual effort and time investment.

This technique is particularly useful for data analysts who need to identify key trends and patterns in large data sets quickly and efficiently, making it a valuable tool in business decision-making scenarios where time is of the essence. In this tutorial, Sam will demonstrate how you can apply Continue reading “Find Your Top 3 Salespeople Per Region Automatically In Power BI Using DAX [2023 Update]” →

Learning to integrate Power BI with Power Platform allows data analysts to leverage the combined power of multiple tools for more efficient and effective data analysis. By integrating Power BI with Power Automate and Power Apps, analysts can streamline their workflows, automate data processing, and create interactive visualizations, making it easier to gain insights and communicate findings.

We are ecstatic to officially launch our new course “Integrating Power BI with the Power Platform” developed by Tim Weinzapfel! In this video, join Komal and Tim as they give an insight on what you can expect from this new course, and how data Continue reading “Integrating Power BI With Power Platform – New Course!” →

The ALLEXCEPT function is a DAX formula in Power BI that allows you to remove filters from a table or column while keeping other filters on the same table or column. Cumulative totals are a common calculation in Power BI where a running total is displayed over time.

However, when a date selection is made, the cumulative total may reset to zero, and this is where the ALLEXCEPT function can be used to stop this from happening. By using the ALLEXCEPT function, you can ensure that your cumulative totals continue to show accurate data, even when a date selection is Continue reading “Using ALLEXCEPT To Stop Cumulative Total From Resetting [2023 Update]” →