Calculate sale the same date of previous month

[vblbiservice]

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 eachday comparing with each day of previous month

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

The result when select week of the month

The result.

Best,

Aynar

[Anonymous]

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

[vblbiservice]

Hi team,

Thanks you so much.

Best,

BI

[Greg_Deckler · Accepted solution]

@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])