Combine 2 Fact Tables With a Date Table?!

Hi, 7ballp25 

You can try the following methods.

Table:

Date = CALENDAR(MIN('Table 1'[Date]),MAX('Table 2'[Date]))

According to your description, Hist Sales and Projected Sales should both be Measure, I simulated it briefly and hope it fits your situation.

Measure:

forecasted sales measure = SUM('Table 2'[Projected Sales])

historical sales measure = SUM('Table 1'[Hist Sales])

Sales = [historical sales measure]+[forecasted sales measure]

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.