Forum Discussion

troy8's avatar
troy8
New Member
9 years ago
Solved

New Measure question and data structure

I have a set of sales data that shows the sales by month for each region for each product.   I want to calculate the number of each product sold for each region per day I was open.  If I write it a...
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    troy8

     

    What does your source table look like?

     

    I assume you should have a fact table which contains the sales per product per month per region. Then you suppose to have another table which includes the opendays associated to each month.

     

    You just nees to build the relationship between two tables on Month columns.

     

     

     

    Then you can easily have sales divided by OpenDays.

     

    sales per day = 'Table 2'[Sales]/RELATED('Month'[OpenDays])

     

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

troy8

 

What does your source table look like?

 

I assume you should have a fact table which contains the sales per product per month per region. Then you suppose to have another table which includes the opendays associated to each month.

 

You just nees to build the relationship between two tables on Month columns.

 

 

 

Then you can easily have sales divided by OpenDays.

 

sales per day = 'Table 2'[Sales]/RELATED('Month'[OpenDays])

 

 

Regards,