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:

  1. With a Calculated Column (always works)
  2. 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