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