Salvatore Cagliari

Calculating a moving Aggregation is easy in DAX. However, there are some pitfalls when calculating the moving average over time. As some of these pitfalls are a question of definition, we must be careful not to choose the wrong method. Let’s look at the details. Salvatore Cagliari · Follow Published in Towards Data Science · 7 min read · 3 hours ago — Photo by Antoine Dautry on Unsplash First, some math Calculating the Average

While hierarchies are a familiar concept with data, some sources deliver their data in an unusual format. Usually, we get our values at the lowest level. But what happens when we get pre-aggregated values? Here, I will dive into this topic. Salvatore Cagliari · Follow Published in Towards Data Science · 8 min read · 7 hours ago — Photo by ThisisEngineering on Unsplash

Implementing row-level security in Power BI is a recurring task for developers. We use various techniques to do so. Let’s look at some of them. Salvatore Cagliari · Follow Published in Towards Data Science · 12 min read · 10 hours ago — Photo by David Clode on Unsplash Introduction When we regulate data access in Power BI solutions, we must implement RLS (Row-level security). RLS works through the implementation of RLS Roles, which contain