Help for joining more table with Date

[Anonymous]

Hello Everybody,

I've got 3 table: one is Offer detail, one other is Sales Order Detail, and  JOB that contains information for the Business Unit where the Sales Order or the Offer come from.

Every Offer and Sales Order Have the Creation Date, I want to show in a single Chart th Value of them, also I want to Show in another Chart the Value per Unit. So I'can't make a relation between a Created Calendar and the Creation Date of the Sales Order and the Offer and at the same Time have a relationship between the JOB with sales Order and JOB with Offer because i create a Cycle.

I want to put the first two chart togheter so i can make them work with just one date, and i can also filter for the Business Unit with the second one.

the second one use a value from JOB, the JOB is linked to the other table with another Parameter.

Can someone help me?

The only things is that i create a support table with a column date, another one is the type, so if is an Order or Offer, the other one is the code of the offer or Order, and another one is the BU. then i create a relationship with the calendar. and i can take the other data, Is this fine

[Greg_Deckler]

Not following this, perhaps you could elaborate with an image of your data model? Sample source data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Thank you Greg,

here a sample of the data set 🙂