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!

Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

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!

Hi, Anonymous
function DATEVALUE should do the trick.

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