Average prices based on Daily quote

For monthly data you can use , for Weekday you can have workday flag

MTD Sales = CALCULATE(Average(Sales[Sales price]),DATESMTD('Date'[Date]),'Date'[Workday]=1)
last MTD Sales = CALCULATE(Average(Sales[Sales price]),DATESMTD(dateadd('Date'[Date],-1,MONTH)),'Date'[Workday]=1)

For Week refer How we can use week rank in file

Current Week =CALCULATE(Average(Sales[Sales price]),Filter(All('Date'),'Date'[Week Rank] = MAx('Date'[Week Rank])),'Date'[Workday]=1)

Refer tgis file for Week : https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0

Hi Anonymous ,

We can use the following steps to meet your requirement.

1. Create three columns which are month, weekday and week.

Month = MONTH('Table'[date])
week = WEEKNUM('Table'[date],2)
weekday = WEEKDAY('Table'[date],2)

2. Then we can create a measure to calculate the average of quotation, the weekday is less than 6 can filter the workday.

Measure = 
var x = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[weekday]<6))
var y = CALCULATE(COUNT('Table'[date]),FILTER('Table','Table'[weekday]<6))
return
x / y

3. At last we can create a matrix table, Month and week in Rows, measure in Values. The result like this,

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.