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 t...
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

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