This post is also available in: Deutsch
Sooner or later, every Power BI developer will face the question of how to automatically filter a specific visual or the entire report to today’s date.
This can be done in two ways:
- With a Calculated Column (always works)
- With a measure (works in specific cases)
The approach with a calculated column is much more stable, since measures generally cannot or should not be used as filters. However, if the date exists in the filter context, then this is also possible with a measure, which is why I will present both alternatives.
Filter to today’s date with calculated column
As just said, filtering by calculated column is the more stable of the two approaches. Here, a new calculated column is created in the date dimension, where it