Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
8 years ago
Solved

Next monday

Hello everyone,   just a little help with this. I need to calculate a date as follows: if today is monday, keep it. If not return the next monday. Thanks in advance. Best wishes
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    II guess you mean a calculated column?

     

    Something like:

     

    NextMonday = DATEADD(Dates[Date],MOD(7-WEEKDAY(Dates[Date],3),7),DAY)
Fcoatis's avatar
Fcoatis
Post Patron
8 years ago

Thank you very much. But I was thinking of a measure.

MarcelBeug's avatar
MarcelBeug
Community Champion
8 years ago

II guess you mean a calculated column?

 

Something like:

 

NextMonday = DATEADD(Dates[Date],MOD(7-WEEKDAY(Dates[Date],3),7),DAY)
  • Fcoatis's avatar
    Fcoatis
    Post Patron
    8 years ago

    That´s it. Thank you.

     

    Happy Holidays.