Import Data valid for all years

Hi Mangnuel.,

The issue with filtering happens because your Calendar table filters by full dates, but your ExtendedTargets table currently only links by Year and Month. Since your Calendar has a unique Date for each day, Power BI can’t filter the ExtendedTargets correctly on just Year and Month.

To fix this, you need to create a full date column in your ExtendedTargets table—typically the first day of each target month and then create a relationship between that date and the Calendar’s Date column.

Add this calculated column to your ExtendedTargets table:
TargetDate = DATE(ExtendedTargets[Year], ExtendedTargets[Month], 1)

Then in the model view, create a relationship between:

ExtendedTargets[TargetDate] and Calendar[Date]

Make sure this relationship is active and single-directional from Calendar to ExtendedTargets.

This way, filtering by any date, month, or year on the Calendar table will correctly filter the targets as well.

I hope my suggestions provided valuable insights. If you have any further questions, don’t hesitate to ask in a follow-up message.
If this post helped, please mark it as "Accept as Solution" so others can benefit as well.

Best regards,
Sahasra.