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,

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Jacy,

 

>>In addition I need to add the accumulated of the month that is smaller than the maximum date selected.

You can try to use TOTALYTD function to calculate the accumulated value.

 

Referencelink:

TOTALMTD Function (DAX)

 

Regards,

Xiaoxin Sheng