Average daily sales x Days in month by Branch

[cocomy]

Hi All,

I have a table of average daily sales by branch by month.  I want to add monthly sales by branch column (days in month x average sales by branch) Could you please help?

(1) Original table

Date           Branch    Average daily sales

1 Jan 2018 Tokyo     3

1 Jan 2018 Osaka     2

1 Jan 2018 Nagoya   1

1 Feb 2018 Tokyo     4

1 Feb 2018 Osaka     3

1 Feb 2018 Nagoya  4

(2) Original table + new measure

Date           Branch    Average daily sales     Days    Average monthly sales

1 Jan 2018 Tokyo     3                                   31       93

1 Jan 2018 Osaka     2                                   31       62

1 Jan 2018 Nagoya   1                                  31       31

1 Feb 2018 Tokyo     4                                  28       112

1 Feb 2018 Osaka     3                                  28       84

1 Feb 2018 Nagoya  4                                  28       112

All the best,

cocomy

[v-jiascu-msft]

Hi @cocomy,

Whether calculated columns or measures, you can find out the solution here.

The measure solution:

Days Measure =
DAY ( EOMONTH ( MIN ( 'Table1'[Date] ), 0 ) )

Average monthly sales measure =
MIN ( 'Table1'[Average daily sales] ) * [Days Measure]

Best Regards,

Dale

[cocomy · Accepted solution]

Hi Dale,

Thank you very much for your help. I was not aware I need to write MIN. Thank you again!

All the best,

cocomy