I'm facing an issue with the creation of a calculated table. I have two tables: a DimDate table and a table "DimWerknemer" containing employees including the dates they started and left the company.
The goal is to create a calculated table showing all employees that were active in the selected period of the DimDate table.
The DAX code below is giving a table containing all employees, it seems to be ignoring the applied filters on DimDate[Dag].
VAR MinDate =
VAR MaxDate =
Any help would be appreciated.