Salvatore Cagliari, Author at Towards Data Science https://towardsdatascience.com Publish AI, ML & data-science insights to a global community of data professionals. Mon, 14 Jul 2025 18:46:49 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.1 https://towardsdatascience.com/wp-content/uploads/2025/02/cropped-Favicon-32x32.png Salvatore Cagliari, Author at Towards Data Science https://towardsdatascience.com 32 32 Tracking Drill-Through Actions on Power BI Report Titles https://towardsdatascience.com/tracking-drill-through-actions-on-power-bi-report-titles/ Mon, 14 Jul 2025 18:46:37 +0000 https://towardsdatascience.com/?p=606568 When you have a drill-through page that can be called from multiple pages, it could be interesting to show which page was the originating page in the page title. Here I will show you how to do it.

The post Tracking Drill-Through Actions on Power BI Report Titles appeared first on Towards Data Science.

]]> Implementing IBCS rules in Power BI https://towardsdatascience.com/implementing-ibcs-rules-in-power-bi/ Tue, 01 Jul 2025 17:13:01 +0000 https://towardsdatascience.com/?p=606469 Is there a way to use the out-of-the-box features of Power BI to be IBCS compliant?

The post Implementing IBCS rules in Power BI appeared first on Towards Data Science.

]]> About Calculating Date Ranges in DAX https://towardsdatascience.com/about-calculating-date-ranges-in-dax/ Thu, 22 May 2025 15:53:28 +0000 https://towardsdatascience.com/?p=606063 When performing date calculations, creating date ranges can be helpful. But how can we do this, and which DAX function can help us in which case? Now you can learn more about this topic.

The post About Calculating Date Ranges in DAX appeared first on Towards Data Science.

]]> The Difference between Duplicate and Reference in Power Query https://towardsdatascience.com/the-difference-between-duplicate-and-reference-in-power-query/ Fri, 02 May 2025 18:38:22 +0000 https://towardsdatascience.com/?p=605886 In Power Query, we can duplicate or reference existing tables. But what are the differences between them? Let's dive into it to find out.

The post The Difference between Duplicate and Reference in Power Query appeared first on Towards Data Science.

]]> How to Get Performance Data from Power BI with DAX Studio https://towardsdatascience.com/how-to-get-performance-data-from-power-bi-with-dax-studio/ Tue, 22 Apr 2025 22:56:25 +0000 https://towardsdatascience.com/?p=605773 Sometimes we have a slow Report, and we need to figure out why. I will show you how to collect performance data and what these metrics mean.

The post How to Get Performance Data from Power BI with DAX Studio appeared first on Towards Data Science.

]]> How to Write Queries for Tabular Models with DAX https://towardsdatascience.com/601823-2/ Mon, 21 Apr 2025 23:02:11 +0000 https://towardsdatascience.com/?p=605758 Introduction EVALUATE is the statement to query tabular models. Unfortunately, knowing SQL or any other query language doesn’t help as EVALUATE follows a different concept. EVALUATE has only two “Parameters”: You can pass a third parameter (START AT), but this one is rarely used. However, a DAX query can have additional components. Those are defined […]

The post How to Write Queries for Tabular Models with DAX appeared first on Towards Data Science.

]]> How to Develop Complex DAX Expressions https://towardsdatascience.com/how-to-develop-complex-dax-expressions/ Tue, 11 Mar 2025 18:39:37 +0000 https://towardsdatascience.com/?p=599491 On the importance of taking some time to thoroughly understand the needs and the possible future use cases for the requested measures

The post How to Develop Complex DAX Expressions appeared first on Towards Data Science.

]]> Advanced Time Intelligence in DAX with Performance in Mind https://towardsdatascience.com/advanced-time-intelligence-in-dax-with-performance-in-mind/ Thu, 20 Feb 2025 00:05:46 +0000 https://towardsdatascience.com/?p=598124 We all know the usual Time Intelligence function based on years, quarters, months, and days. But sometimes, we need to perform more exotic timer intelligence calculations. But we should not forget to consider performance while programming the measures.  Introduction  There are many DAX functions in Power BI for Time Intelligence Measures.  The most common are:  You […]

The post Advanced Time Intelligence in DAX with Performance in Mind appeared first on Towards Data Science.

]]> How to do Date calculations in DAX https://towardsdatascience.com/how-to-do-date-calculations-in-dax-95e792f65e5e/ Tue, 28 Jan 2025 17:01:59 +0000 https://towardsdatascience.com/how-to-do-date-calculations-in-dax-95e792f65e5e/ Moving back and forth in time is a common task for Time Intelligence in DAX. Let's take a deeper look on how DATEADD() works.

The post How to do Date calculations in DAX appeared first on Towards Data Science.

]]> Calculating a linear extrapolation (or Trend) in DAX https://towardsdatascience.com/calculating-a-linear-extrapolation-or-trend-in-dax-72a5705d949c/ Thu, 26 Dec 2024 12:01:34 +0000 https://towardsdatascience.com/calculating-a-linear-extrapolation-or-trend-in-dax-72a5705d949c/ In DAX there is no built-in method to calculate a Trend. Therefore we must do it manually. Let's look at how to do it.

The post Calculating a linear extrapolation (or Trend) in DAX appeared first on Towards Data Science.

]]> The Ten Commandments for (Power BI) Reporting https://towardsdatascience.com/the-ten-commandments-for-power-bi-reporting-508cbe81f7e7/ Tue, 03 Dec 2024 14:02:19 +0000 https://towardsdatascience.com/the-ten-commandments-for-power-bi-reporting-508cbe81f7e7/ I have been asked about some basic rules when creating a reporting solution. Here I am writing down ten commandments on this topic.

The post The Ten Commandments for (Power BI) Reporting appeared first on Towards Data Science.

]]> While Using RLS When Manipulating Relationships in Power BI, What Can Go Wrong? https://towardsdatascience.com/while-using-rls-when-manipulating-relationships-in-power-bi-what-can-go-wrong-708c0996038a/ Tue, 05 Nov 2024 18:31:50 +0000 https://towardsdatascience.com/while-using-rls-when-manipulating-relationships-in-power-bi-what-can-go-wrong-708c0996038a/ There are restrictions when manipulating Relationships with RLS in place. The MS documentation doesn't provide details so let's look at it.

The post While Using RLS When Manipulating Relationships in Power BI, What Can Go Wrong? appeared first on Towards Data Science.

]]> How to Calculate a Moving Average Over Multiple Periods in DAX https://towardsdatascience.com/how-to-calculate-a-moving-average-over-multiple-periods-in-dax-2a6a8105850a/ Tue, 01 Oct 2024 23:20:00 +0000 https://towardsdatascience.com/how-to-calculate-a-moving-average-over-multiple-periods-in-dax-2a6a8105850a/ Calculating a moving Aggregation is easy in DAX. However, there are some pitfalls when calculating the moving average. Let's look into it.

The post How to Calculate a Moving Average Over Multiple Periods in DAX appeared first on Towards Data Science.

]]> How to Dynamically Restrict Data Import in Power Query https://towardsdatascience.com/how-to-dynamically-restrict-data-import-in-power-query-68a29fce0640/ Tue, 06 Aug 2024 10:49:11 +0000 https://towardsdatascience.com/how-to-dynamically-restrict-data-import-in-power-query-68a29fce0640/ When we have a large amount of data, we might ask: Do I really need all this data in my reporting? If no, read this piece to learn more.

The post How to Dynamically Restrict Data Import in Power Query appeared first on Towards Data Science.

]]> How to Manipulate the Total in Power BI https://towardsdatascience.com/tablehow-to-manipulate-the-total-in-power-bi-b55e2d07207d/ Tue, 16 Jul 2024 06:23:01 +0000 https://towardsdatascience.com/tablehow-to-manipulate-the-total-in-power-bi-b55e2d07207d/ In most cases, the total aggregates the detail rows in a visual. But what if the Total should show something different?

The post How to Manipulate the Total in Power BI appeared first on Towards Data Science.

]]> Using Power BI for Planning (Warehouse) with Stock Values https://towardsdatascience.com/using-power-bi-for-planning-warehouse-with-stock-values-0c7219845d48/ Tue, 18 Jun 2024 06:31:48 +0000 https://towardsdatascience.com/using-power-bi-for-planning-warehouse-with-stock-values-0c7219845d48/ How can we use Power BI to plan for the future using Stock-Measures? Here, I show you a possible approach.

The post Using Power BI for Planning (Warehouse) with Stock Values appeared first on Towards Data Science.

]]> How to apply RLS based on multiple columns in Power BI https://towardsdatascience.com/how-to-apply-rls-based-on-multiple-columns-in-power-bi-2c67f980983f/ Thu, 23 May 2024 05:53:22 +0000 https://towardsdatascience.com/how-to-apply-rls-based-on-multiple-columns-in-power-bi-2c67f980983f/ Usually, Data Access with RLS is based on Data from one column. But what when Data access must be controlled by multiple columns?

The post How to apply RLS based on multiple columns in Power BI appeared first on Towards Data Science.

]]> On Handling Precalculated Hierarchical Data in Power BI https://towardsdatascience.com/on-handling-precalculated-hierarchical-data-in-power-bi-4a215b96b99c/ Fri, 03 May 2024 19:56:06 +0000 https://towardsdatascience.com/on-handling-precalculated-hierarchical-data-in-power-bi-4a215b96b99c/ While hierarchies are a familiar concept with data, some sources deliver their data in an unusual format. Let's see a not-so-unusual case.

The post On Handling Precalculated Hierarchical Data in Power BI appeared first on Towards Data Science.

]]> Calculating the previous value in Power BI https://towardsdatascience.com/calculating-the-previous-value-in-power-bi-9ddc062ef2df/ Fri, 19 Apr 2024 19:05:54 +0000 https://towardsdatascience.com/calculating-the-previous-value-in-power-bi-9ddc062ef2df/ Calculating the consumption based on meter data looks easy. However, complex situations can be challenging. Let's see how we can solve...

The post Calculating the previous value in Power BI appeared first on Towards Data Science.

]]> Explore all ways to implement RLS Rules https://towardsdatascience.com/explore-all-ways-to-implement-rls-rules-ee4a402db39a/ Wed, 03 Apr 2024 16:56:57 +0000 https://towardsdatascience.com/explore-all-ways-to-implement-rls-rules-ee4a402db39a/ Implementing row-level security in Power BI is a recurring task for developers. Let's look at the techniques for implementing it.

The post Explore all ways to implement RLS Rules appeared first on Towards Data Science.

]]>