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 .