Slider data for multiple tables

[pagliaci]

Hello! 

I have 4 tables with the answers from a form and the date it was completed (1column is the answer and 1 clumn the date)

For example:

Those tables are not originally related between them. 

My goal is to create one slider to show the amounts of "YES" on each answer in the specific date and this should filter those 4 tables at once. I tried to create a new table that gets all the dates and I related my 4 tables to this 5th. But I cannot activate my relationships, so I am trying to create a mesure with USERELATIONSHIPS on my cart. But this is not going well: 

Mistakes = CALCULATE(COUNT(Table 1 [Answer]),(USERELATIONSHIP(Data[Date].[Date],Table1[Date])),Table1[Answer]=""YES")

Does anyone know which would be a best solution?

Thanks a lot!

[HotChilli]

You say "tried to create a new table that gets all the dates" Is this a Dates table created with CALENDAR or CALENDARAUTO?  It sounds like that's what you need.

Also is there a way to combine your tables into 1 (in Power Query)?  That will make things easier.

[pagliaci]

I ended up making 

Erro  = CALCULATE(COUNT(LV90[Checklist Desafios 90]), USERELATIONSHIP(LV90[Data], All_Date[Date]), LV90[Checklist Desafios 90]="Erro GCAS/Lote")