How to get MTD sales

[jason_ocp90]

Hi. I have YTD Sales data in each month. How to get the MTD sales for each period using DAX formula?

	YTD Sales
Jan	100
Feb	150
Mar	170
Apr	200
May	500

[talespin · Accepted solution]

Hi @jason_ocp90 

If your sales# are Year to Month then please try below measures which will return monthly sales numbers.

Sales Amt YTD = SUM('YTD'[YTD Sales])

-----------------------------------------------------------

Monthly Sales =

VAR _SelMonthNo = SELECTEDVALUE('YTD'[MonthNo])

VAR _PrevMonthNo = CALCULATE( MAX('YTD'[MonthNo]), REMOVEFILTERS(), 'YTD'[MonthNo] < _SelMonthNo)

VAR _PreviousSales = CALCULATE( [Sales Amt YTD], REMOVEFILTERS(), 'YTD'[MonthNo] = _PrevMonthNo)

RETURN [Sales Amt YTD] - _PreviousSales

[lbendlin]

Do you have daily sales data?

[jason_ocp90]

Unfortunately no...The data is at YTD basis every month

[lbendlin]

MTD requires data to be at day level granularity.