topic Calculate sale the same date of previous month in DAX Commands and Tips

Calculate sale the same date of previous month

vblbiservice — Mon, 17 Oct 2022 01:20:06 GMT

Hi team,

I would seek your suppoting. I want to get sale for the same date of previous month.

I have fielter weekly of the month for sale and then when I select the week to show line chart with current week of each

when select week of the month the graph will show current day capring the days of previous month.

The result.

Best,

Aynar

Re: Calculate sale the same date of previous month

Greg_Deckler — Mon, 17 Oct 2022 01:53:11 GMT

vblbiservice Hard to be specific without your actual data but maybe something like:

Measure = VAR __Current = MAX('Table'[Date]) VAR __PM = EOMONTH(__Current,-1) VAR __Previous = DATE(YEAR(__PM),MONTH(__PM),DAY(__Current)) RETURN SUMX(FILTER('Table',[Date] = __Previous),[Value])

Re: Calculate sale the same date of previous month

Anonymous — Tue, 25 Oct 2022 01:19:18 GMT

Hi vblbiservice ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

Re: Calculate sale the same date of previous month

vblbiservice — Fri, 28 Oct 2022 04:53:06 GMT

Hi team,

Thanks you so much.

Best,