Forum Discussion

mon's avatar
mon
Frequent Visitor
3 years ago

Hi, How to make the report dynamic with two different dates?

Hi, I have created multiple tables in the report. My 'X' table is based on one date " shipped date" and 'Y' table is based on "Return date" . However as i am using two different active relationship ...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi mon,

 

Do you have a calendar table to make the relationship between the tables?

 

 

  • mon's avatar
    mon
    Frequent Visitor
    3 years ago

    Hi MFelix ,

    Thanks for the reply. I used common fiscal calender table where i related it with the "shipped date". However, the X table values were coming right. But Y table values were coming wrong as it is dependednt on "returned date" as the returned date is completely different from the shipped date.

     

    Thanks.

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      3 years ago

      Hi mon 

       

      What do you mean by the values are coming wrong? Are you using the date tables on your visualizations and filters?

       

      Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

      If the information is sensitive please share it trough private message.

      • mon's avatar
        mon
        Frequent Visitor
        3 years ago

        Sure MFelix . Thanks .