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!

v-kelly-msft's avatar
v-kelly-msft
Community Support
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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for you help, it works!!