Forum Discussion

7ballp25's avatar
7ballp25
Regular Visitor
4 years ago
Solved

Combine 2 Fact Tables With a Date Table?!

I have 1 fact table who's data is in direct query with sql server = this has 2018-2022 data  I created another table using Dax Union and row function - and used a few forecasting measures to get pro...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

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.