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
Arul's avatar
Arul
Icon for Super User rankSuper User
3 years ago

mon ,

To achieve this you have to create common date table and make the relationship from "Date table"[Date column] to "'X' table" [shipped date column] and "Date table"[Date column] to "'Y' table" [Return date column]. Now you can use the dates from Date table that would filter the data from both tables accordingly based on the relationship.
You can refer the video and blog in the below links for date table creation,
https://youtu.be/Pzn2B4laK9A 
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns 

Thanks,

  • mon's avatar
    mon
    Frequent Visitor
    3 years ago

    Hi Arul

    Thank you so much for your kind reply. However, I need to use two different dates as these two tables are based on two different dates. X is based on Shipped date and Y table is based on Returned date. Do you have any other suggestions how to relate them together? Because previously i used only Shipped date for both of the tables and the values were wrong for the Y table. then found out that the dates are different in Returned date and Y table is dependent on that. But now that i used two different dates, the report is not dynamic anymore. 😞

    Kindly advise!

    Thanks.