multiple fact tables with dates with relations to one date table

[DotanBartov]

hi there

i have a sales fact table with date column and a purchase orders fact table with a date column.

both in relation to a date table

I'm having some trouble with showing on the sam table the average qunatity sold in the last 4 months (from the sales fact) and the quantities orders from the purchase fact table.

Becuase the avg. sold from sales fact table is refering to history time and purchase order table refers to the future...the numbers dont go together.

do you have any idea?

thank's

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[DotanBartov]

hi Ibendlin

it's a bit hard for me to provide a sample of my data because it's mixed up with different tables.

it will be much easier to show it by Zoom or Teams if this possible (dont know if its ok...)

thank's

Dotan

[lbendlin]

You will find that the process of creating a sample PBIX will help you to clearly articulate the issue (and maybe even find a solution yourself).

[DotanBartov]

hi Ibendlin

thank's for your help, i managed to solve it with 2 Date tables with relationships

regards

Dotan