I want to create a measure which calculates sales based on working days in different countries (three country: DE,AT,CH).
There are two major tables for sales and calender in my data set.
The sales table includes all information about orders in each country and calender table includes all dates and three binary columns for working days in each country.
Now I want to create a measure which calculates avrage of Sales in each country divided by SUM of working days in year/month.
I would appreciate, if someone can help me with this issue.