Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mon
Frequent Visitor

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 with two different tables it is getting hard to make it dyna,ic. Do you guys have any suggestions or advise in this please?

 

Any kind of help will be appreciated.

Thanks.

7 REPLIES 7
mon
Frequent Visitor

Hi @amitchandak , @Mikelytics , @MFelix , @Greg_Deckler , @Jihwan_Kim , Can you guys guide me in this please?

Thanks.

Hi @mon,

 

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

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



mon
Frequent Visitor

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.

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



mon
Frequent Visitor

Sure @MFelix . Thanks .

Arul
Super User
Super User

@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,





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


mon
Frequent Visitor

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.