Total sales for the previous month by salesperson

[kasife]

Hi Guys,
I'm trying to get last month's total sales for each salesperson. But as I'm using it, it's not working. What's wrong with the measurement?

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

[ProjectKM]

There seems to be no problem with measure.

Check d_calendario has a Mark as date table set or check the connection between d_calendario and fact table

[kasife]

Hi @ProjectKM 

I checked and the relationship is ok. When I use segmentation it works

[ProjectKM · Accepted solution]

I test with simple data and it came out like this.

Is the result you want the same as above?

[kasife]

@ProjectKM 
I 'd like a measure without using date slicer.

[ProjectKM]

Oh, I understood. Then try this.

_LM = 
CALCULATE(
    [_Total Amount],
    FactTable[YYYYMM] = FORMAT(EDATE(TODAY(), -1), "YYYYMM")
)

Write the date you want in the TODAY() part.

[kasife]

@ProjectKM 
I used this measure and its working. Thanks

   VAR _toDay= TODAY()

   VAR  _EndtDate = EOMONTH( _toDay,-1)

   VAR _StartDate = EOMONTH( _toDay,-2)+1

 RETURN

CALCULATE(

    [_Total vendas],

    d_calendario[Date] >= _StartDate && d_calendario[Date] <=_EndtDate)