last month sales by category

[kasife]

Hi Guys,

How could I calculate the value of last month's sales by category?

I created the below measure, but when I put it in the pie chart, it gives me the total value of the category, and I would like to get only the last month's value

_Total Vendas LM = 
CALCULATE(
    [_Total vendas],
    DATEADD(d_calendario[Date],-1,MONTH))

Result I would like to get in the graph above: 

[Ahmedx]

try this

_Total Vendas LM = 
   VAR _toDay= TODAY()
   VAR _StartDate = EOMONTH( _toDay,-1)
   VAR _EndtDate = EOMONTH( _toDay,-2)+1
 RETURN
CALCULATE(
    [_Total vendas], FILTER(ALL(d_calendario),
    d_calendario[Date] >= _StartDate && d_calendario[Date] <=_EndtDate))

[Ahmedx]

Share sample pbix file to help you

[Ahmedx · Accepted solution]

pls try this

_Total Vendas LM = 
   VAR _toDay= TODAY()
   VAR _StartDate = EOMONTH( _toDay,-1)
   VAR _EndtDate = EOMONTH( _toDay,-2)+1
 RETURN
CALCULATE(
    [_Total vendas],
    d_calendario[Date] >= _StartDate && d_calendario[Date] <=_EndtDate)

[kasife]

@Ahmedx  Thank you so much.

It worked, I was just changing the beginning of the month and the end of the month, that's why I was bringing empty.

[kasife]

@Ahmedx It didn't work, it's blank.