Forum Discussion

Reimer's avatar
Reimer
Helper II
5 years ago
Solved

Next monday

I would like a new calculated column date as follows: if today is monday, keep it. If not return the next monday.    Ive tried this: NextMonday = DATEADD(Dates[Date],MOD(7-WEEKDAY(Dates[Date],3),7...
Need Help
  • Reimer's avatar
    Reimer
    5 years ago

    Ive tried this as well. But the formula doesnt keep the monday:

     

    Maandag publicatie = 'Procedures - Power BI'[Invoerdatum].[Date] - WEEKDAY('Procedures - Power BI'[Invoerdatum],2)+8
Reimer's avatar
Reimer
Helper II
5 years ago

Ive tried this, but is still not quite working. If I use:

 

Next monday = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+8

 

Then all days of the week change in the next monday. But also the mondays change in the next monday. But mondays must remain the same.

 

So:

 

Monday 1 januari --> Monday 1 januari

Thuesday 2 januari --> Monday 8 januari

Wednessday 4 januari --> Monday 8 januari

Etc.

amitchandak's avatar
amitchandak
Super User
5 years ago

Reimer , Try this if not resolved yet

Next monday = if(WEEKDAY([Date],2)=1, [Date],'Date'[Date]+ 8-1*WEEKDAY('Date'[Date],2) )
  • Reimer's avatar
    Reimer
    Helper II
    5 years ago

    WAUW, it is working.

     

    Thank you all for your great help and patience!