Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DATEADD AND MAX

Hello,   I am in trouble with DATEADD DAX function.   For now, I have two functions which are running efficiently.   Current Month default phase = CALCULATE(SUM('public costs phase'[Heures mens...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Modify the expression of "MAX(DATEADD('public costs phase'[Monthly Date],-1,month))" as below:

    MAXX(DATEADD('public costs phase'[Monthly Date],-1,month),[Monthly Date])

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!