Salvatore CagliariinTowards Data ScienceHow to apply RLS based on multiple columns in Power BIUsually, Data Access with RLS is based on Data from one column. But what when Data access must be controlled by multiple columns?·9 min read·May 23, 2024----
Salvatore CagliariinTowards Data ScienceOn Handling Precalculated Hierarchical Data in Power BIWhile hierarchies are a familiar concept with data, some sources deliver their data in an unusual format. Let’s see a not-so-unusual case.·8 min read·May 3, 2024----
Salvatore CagliariinTowards Data ScienceCalculating the previous value in Power BICalculating the consumption based on meter data looks easy. However, complex situations can be challenging. Let’s see how we can solve…·10 min read·Apr 19, 2024--1--1
Salvatore CagliariinTowards Data ScienceExplore all ways to implement RLS RulesImplementing row-level security in Power BI is a recurring task for developers. Let’s look at the techniques for implementing it.·12 min read·Apr 3, 2024----
Salvatore CagliariinTowards Data ScienceVisualize a business process through data serializationSometimes, we want to visualize a business process in Power BI. This is not easy, depending on the visualization needed.·11 min read·Mar 15, 2024----
Salvatore CagliariinTowards Data ScienceCalculate the percentage of the total with RLS in place in Power BIWith RLS in place, some users can see only some aspects of the data set. But what happens when they must compare the result to the total?·11 min read·Feb 5, 2024----
Salvatore CagliariinTowards Data ScienceAbout Calculating Sales depending on another Value in DAXMeasures aggregate the Values from columns in one Fact table. But what if we need a dependency to another table?·7 min read·Jan 18, 2024----
Salvatore CagliariinTowards Data ScienceConverting a Flat Table to a Good Data Model in Power QueryWhen loading a wide Excel table into Power BI, we end up with a suboptimal Data model. What can we do to create a good Data model?·12 min read·Dec 22, 2023--2--2
Salvatore CagliariinTowards Data ScienceGoing the Next Step with Stock Measures in DAXWe can have some weird effects when using Stock Measures in Power BI. Let’s look at how such a situation can emerge and how to solve it.·7 min read·Nov 28, 2023----
Salvatore CagliariinTowards Data ScienceExplore variants of Time Intelligence in DAXIn DAX, we have several functions to calculate time intelligence results easily. As this is a main topic in DAX, let’s explore some details·11 min read·Nov 6, 2023----