how much did customer spend in the last 12 months

[JeromeTEL]

I want to know how much a customer have spend in the last 12 months locally.

In my matrix table, I added a customer ID Column and the below measure

ID	12M Spend Local
2311A	$2,178

This is not what I want because instead of looking at 365 days prior to his last purchase, I need to know how much he spent over the last 365 days ending today / a specific date.

In this case the customer did not purchase in the last 12 months, hence the result should be

ID	12M Spend Local
2311A	$0

Thank you in advance.

12M Spend Local =

CALCULATE(SUM(Transactions[Sales USD excl. Tax]),

  DATESBETWEEN(Transactions[Transaction Date],

    MAX(Transactions[Transaction Date]) - 365,

    MAX(Transactions[Transaction Date])),

  Transactions[LOCALS] = True)

[johnt75]

Change the MAX( Transactions[Transaction Date] ) to TODAY().

12M Spend Local =
CALCULATE(SUM(Transactions[Sales USD excl. Tax]),
  DATESBETWEEN(Transactions[Transaction Date],
    TODAY() - 365,
    TODAY() ),
  Transactions[LOCALS] = True)