Forum Discussion
Understanding Multiple Fact Tables
Hi,
My approach would be to write a calculated column formula in the Campaign Table to get the Amount from the Fact- Sales Orders Table. For this we will have to first convert the DateKey column into an actual date column (the way dates are in the Campaign table). Once we have the Amount column in the Campaign table, we just have to write a simple SUM measure.
Are you OK with this approach.
Hi Ashish_Mathur , how to create this calculated column to get the according amount from the Sales table ? since there is 2 dates column , in Excel I would use SumIfs to calcualte the sales mount between the Start date and End Date of the campaign; would be helpful if you could help write an example
Ashish_Mathur for the Fact-Sales table I cannot modify since it's in a Direct Query 😞
can I create calculated column (since the datekey is related to the calendar date table ) ?
Hi,
I am not aware of any other way.