Forum Discussion

Jacy's avatar
Jacy
Frequent Visitor
9 years ago
Solved

LastDate minus 1

Good morning, I need to add the value of a measure to the maximum date of the base minus one day. As I developed it does not work, it follows $ Recipe D = CALCULATE ([Recipe]; LASTDATE ('Data Link' -...
Need Help
  • ibarrau's avatar
    ibarrau
    9 years ago

    Hello there. Even I didn't understand the cumulative part, i think this can help.

     

    Recipe = CALCULATE(SUM('Table'[NumberRecipe]); DATEADD(LASTDATE('Table'[Date]); -1;DAY)) 

     

    Regards,

     

     

Jacy's avatar
Jacy
Frequent Visitor
9 years ago

Good morning, I need to add the value of a measure to the maximum date of the base minus one day. As I developed it does not work, it follows $ Recipe D = CALCULATE ([Recipe]; LASTDATE ('Data Link' - 1).
In addition I need to add the accumulated of the month that is smaller than the maximum date selected.