two date filter

[firstligth62]

Hi
I have two tables "circulations" and "retard"
I have a problem when I make a filter by the date table "circulations " or table "retards" one data only change  (example: pictures 1 &3)
relation table: picture 2) .

Can you help me, please?

relation 

[v-xicai]

Hi @firstligth62  ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.

Best regards

Amy Cai

[firstligth62]

thanks

[v-xicai]

Hi @firstligth62 ,

You can create a calculated table ,and then create one to many relationships with the tables "circulations" and "retard" on date column. Or you can share your sample data or desired output screenshots for further analysis. You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

DateDim = CALENDARAUTO()

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[firstligth62]

hello v-xicai

thanks but

i tested your answer but she doesn t work

[v-xicai · Accepted solution]

Hi @firstligth62 ,

Did you create a calculated table using DateDim = CALENDARAUTO() ?

Best Regards,

Amy