Forum Discussion

Greenwoodr's avatar
Greenwoodr
Helper I
7 years ago

Understanding Multiple Fact Tables

Hi I would be grateful for some assitance with the following data model design query.......     I have the following structure    1) Fact Table 1 Sales :(1 row per sale) : Contains details of s...
Need Help
VuongLM93's avatar
VuongLM93
Helper III
4 years ago

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's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

You may download the PBI file from here.

Hope this helps.

  • VuongLM93's avatar
    VuongLM93
    Helper III
    4 years ago

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    I am not aware of any other way.