I've created a date key table as a filter for all my other tables. But the filter doesn't work.

[TommyWommy]

I've followed the steps from this link - https://radacad.com/power-bi-from-and-to-date-filtering-with-one-slicer

I'm confident I have copied it exactly except for table names, but it won't filter my tables. Has anyone had this issue, or would know why this issue is occuring?

I've attached the DAX I have used. hopefully someone can see an issue. I'm expecting it to count the number of parts made between a start date column and end date column. But i get 0 always.

[Samarth_18 · Accepted solution]

Hi @TommyWommy 

You could try with replacing Firstdate to MAX and Lastdate to MIN.

Thanks,

Samarth