Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

sum if date <

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[c...
Need Help
Tips and Tricks
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    Hi, Anonymous 
    function DATEVALUE should do the trick.

    CALCULATE(SUM(curva_integrada[cantidad_stock]);curva_integrada[fecha_ultimo_ingreso] < DATEVALUE("10/03/2021"))
vojtechsima's avatar
vojtechsima
Super User
4 years ago

Hi, Anonymous 
function DATEVALUE should do the trick.

CALCULATE(SUM(curva_integrada[cantidad_stock]);curva_integrada[fecha_ultimo_ingreso] < DATEVALUE("10/03/2021"))
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    thanks vojtechsima , that was very helpful!!!!

    • vojtechsima's avatar
      vojtechsima
      Super User
      4 years ago

      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>)