MoM sales volume

[slyfox]

Hello,

Im looking for the formula which can return MoM sales based on MTD number of days.
for exampls If today 09-Aug, I would like to see sum of sales previous month to date 09-Jul.

Data model simple Sales volume table <-> Date Callendar  

[v-frfei-msft · Accepted solution]

Hi @slyfox,

Based on my test, we can take the following steps to meet your requirement.

1.Enter the data and create relationship between Sales volume table and Date Callendar table.

2.create a measure as below to get the excepted result.

pre = var 
dat = SELECTEDVALUE('Date Callendar'[Date])
return 
IF(ISFILTERED('Date Callendar'[Date]),IF(MONTH(dat)=1,CALCULATE(SUM('Sales volume'[sales]),FILTER(ALL('Sales volume'), DATE(YEAR(dat)-1,12,1)<='Sales volume'[date] && 'Sales volume'[date] <=DATE(YEAR(dat)-1,12,DAY(dat)))),CALCULATE(SUM('Sales volume'[sales]),FILTER(ALL('Sales volume'), DATE(YEAR(dat),MONTH(dat)-1,1)<='Sales volume'[date] && 'Sales volume'[date] <=DATE(YEAR(dat),MONTH(dat)-1,DAY(dat))))),BLANK())

For more details, please check the pbix as attached. If it doesn’t meet your requirement, kindly share me sample data of your table and tell me what is your excepted result.

https://www.dropbox.com/s/kwrf61knwqjbe0q/MoM%20sales%20volume%202.pbix?dl=0

Regards,

Frank

[v-frfei-msft]

Hi @slyfox,

Does that make sense? If so, kindly mark my answer as a solution to close the case please.

Regards,

Frank