Author: Salvatore Cagliari
-
We all know the usual Time Intelligence function based on years, quarters, months, and days.…
18 min read -
Moving back and forth in time is a common task for Time Intelligence in DAX.…
6 min read -
In DAX there is no built-in method to calculate a Trend. Therefore we must do…
10 min read -
I have been asked about some basic rules when creating a reporting solution. Here I…
12 min read -
There are restrictions when manipulating Relationships with RLS in place. The MS documentation doesn’t provide…
8 min read -
Calculating a moving Aggregation is easy in DAX. However, there are some pitfalls when calculating…
7 min read -
When we have a large amount of data, we might ask: Do I really need…
9 min read -
In most cases, the total aggregates the detail rows in a visual. But what if…
8 min read -
How can we use Power BI to plan for the future using Stock-Measures? Here, I…
11 min read