Daily Average Sales by Workingdays

[mbb]

Hello,

I have two tables; one is for sale, warehouse name and order date,the other is for dates and working dates. I have connected these two tables. However, 

I want to create a new measure which is Sales / Working Days for each warehouses. For example; for the table below, I would like to have new calculated column, Avg Sales Per Day,  and i.e. for 2021 January the value should be 1237/19, For 2021 February =863/19, for 2021 March 1239/23 and so on. In the example I populate only one warehouse, but i have more than one.

Any help on how to do it?

Thank you so much in advance

[amitchandak]

@mbb , Try like

divide(Sum(Table[sales]), COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Min('Date'[Date]),Max('Date'[Date])),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1)))