sum if date <

[Anonymous]

hi, I have a table like this.

I need a measure to sum STOCK if date is<2022-03-10 (year= 2022, month= 03, day=10) I tried like this:

cantidad stock viejo = CALCULATE(SUM(curva_integrada[cantidad_stock]);curva_integrada[fecha_ultimo_ingreso] < 2022-03-10)

cantidad stock viejo = CALCULATE(SUM(curva_integrada[cantidad_stock]);curva_integrada[fecha_ultimo_ingreso] < 10-03-2022)

and all possible combinations, but it´s not working...what am I doing wrong??

thanks in advance!

[vojtechsima · Accepted solution]

Hi, @Anonymous 
function DATEVALUE should do the trick.

CALCULATE(SUM(curva_integrada[cantidad_stock]);curva_integrada[fecha_ultimo_ingreso] < DATEVALUE("10/03/2021"))

[Anonymous]

thanks @vojtechsima , that was very helpful!!!!

[vojtechsima]

@Anonymous 
Happy to help, also there's another option and that is to use function DATE, where you would construct the date like this: 

DATE(<year>, <month>, <day>)