Create a measure to calculate (Period on Period) total orders

[lawada]

hello, 

im trying to create a masure that calculates for example number of orders in Week2 in this month and total orders in the same week number ( Week 2) in the previous month.

then i want to calculate Peiod on Period by this formula : (( Total orders in the selected week number- total orders in the same week number last month)/total orders in the same week number last month).

[amitchandak]

@lawada , create a month week

Start Month = STARTOMONTH('Date'[Date])
Month Week = QUOTIENT(DATEDIFF(Minx(FILTER('Date',[Start Month]=EARLIER([Start Month])),'Date'[Start of Week]),[Date],DAY),7)+1

now you can measure like

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]), filter(Date,date[Month Week] =2))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)),, filter(Date,date[Month Week] =2))