Salvatore Cagliari – Medium

Salvatore Cagliari

Salvatore Cagliari
in
Towards Data Science

On Handling Precalculated Hierarchical Data in Power BI

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.

8 min readMay 3, 2024

--

On Handling Precalculated Hierarchical Data in Power BI

--

Salvatore Cagliari
in
Towards Data Science

Calculating the previous value in Power BI

Calculating the consumption based on meter data looks easy. However, complex situations can be challenging. Let’s see how we can solve…

10 min readApr 19, 2024

--

1

Calculating the previous value in Power BI

--

1

Salvatore Cagliari
in
Towards Data Science

Explore all ways to implement RLS Rules

Implementing row-level security in Power BI is a recurring task for developers. Let’s look at the techniques for implementing it.

12 min readApr 3, 2024

--

Explore all ways to implement RLS Rules

--

Salvatore Cagliari
in
Towards Data Science

Visualize a business process through data serialization

Sometimes, we want to visualize a business process in Power BI. This is not easy, depending on the visualization needed.

11 min readMar 15, 2024

--

Visualize a business process through data serialization

--

Salvatore Cagliari
in
Towards Data Science

Calculate the percentage of the total with RLS in place in Power BI

With 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 readFeb 5, 2024

--

Calculate the percentage of the total with RLS in place in Power BI

--

Salvatore Cagliari
in
Towards Data Science

About Calculating Sales depending on another Value in DAX

Measures aggregate the Values from columns in one Fact table. But what if we need a dependency to another table?

7 min readJan 18, 2024

--

About Calculating Sales depending on another Value in DAX

--

Salvatore Cagliari
in
Towards Data Science

Converting a Flat Table to a Good Data Model in Power Query

When 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 readDec 22, 2023

--

2

Converting a Flat Table to a Good Data Model in Power Query

--

2

Salvatore Cagliari
in
Towards Data Science

Going the Next Step with Stock Measures in DAX

We 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 readNov 28, 2023

--

Going the Next Step with Stock Measures in DAX

--

Salvatore Cagliari
in
Towards Data Science

Explore variants of Time Intelligence in DAX

In 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 readNov 6, 2023

--

Explore variants of Time Intelligence in DAX

--

Salvatore Cagliari
in
Microsoft Power BI

Finding managers in organizational hierarchies

Organizational hierarchies are one of the most common hierarchies in data. But, finding managers can be challenging. Let’s see how to do…

9 min readOct 9, 2023

--

Finding managers in organizational hierarchies

--

Salvatore Cagliari

Salvatore Cagliari

Nerd passionate about technology, and space science and interested in many other things. On the Business side, an expert in Data Analytics and Power BI.

Following

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams