topic Re: multiple fact tables with dates with relations to one date table in DAX Commands and Tips

multiple fact tables with dates with relations to one date table

DotanBartov — Sat, 22 Apr 2023 13:34:32 GMT

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

Re: multiple fact tables with dates with relations to one date table

lbendlin — Thu, 27 Apr 2023 02:23:23 GMT

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-p/963216
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

Re: multiple fact tables with dates with relations to one date table

DotanBartov — Sat, 29 Apr 2023 13:45:16 GMT

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

Re: multiple fact tables with dates with relations to one date table

lbendlin — Sat, 29 Apr 2023 15:20:19 GMT

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

Re: multiple fact tables with dates with relations to one date table

DotanBartov — Fri, 05 May 2023 07:54:04 GMT

hi Ibendlin

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

regards

Dotan