Calculated column - last 365 days sales

[webportal]

I'm trying to create a calculated column with the sales of the last 365 days:

Sales365D =

VAR EsteCLiente = 'customerSales'[CustomerID]

VAR EstaData = 'customerSales'[Date]

VAR DataAnterior = DATE(YEAR(EstaData)-1, MONTH(EstaData), DAY(EstaData))

RETURN

CALCULATE (

SUM ( customerSales[Sales] ),

FILTER (

ALL ( customerSales ),

customerSales[CustomerID] = EsteCLiente &&

'customerSales'[Date] > DataAnterior &&

'customerSales'[Date] <= EstaData

)

)

But why is this returning the wrong value for 20-12-2018?

[webportal]

It is correct ...
😁

[amitchandak · Accepted solution]

@webportal , To me, it seems correct, check for some decimal place. Increase the decimal place in column tools and check

else

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.