Forum Discussion

firstligth62's avatar
firstligth62
Regular Visitor
7 years ago
Solved

two date filter

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 

 

Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi firstligth62 ,

     

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

     

    Best Regards,

    Amy

5 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    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's avatar
      firstligth62
      Regular Visitor
      7 years ago

      hello v-xicai

       

      thanks but

      i tested your answer but she doesn t work

      • v-xicai's avatar
        v-xicai
        Community Support
        7 years ago

        Hi firstligth62 ,

         

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

         

        Best Regards,

        Amy

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    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