Count same day last month by category

[Anonymous]

Hi,

I have a dataset which have columns as follows:

And I would like to present count of customers by date along with the count value from same day on previous month as follows:

I tried to write down the measure for that, but unfortunately, it displays the summed value regardless of the category.

I have a calendar table & database table in the model. 

Could you please help me with writing proper measures?

Thank you!

[amitchandak · Accepted solution]

@Anonymous , Try a month behind measure like given example with help from date table

Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))