cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Post Patron

## 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

1 ACCEPTED SOLUTION
Community Champion

II guess you mean a calculated column?

Something like:

`NextMonday = DATEADD(Dates[Date],MOD(7-WEEKDAY(Dates[Date],3),7),DAY) `
Specializing in Power Query Formula Language (M)
4 REPLIES 4
Community Champion

In Power Query, you can use Date.EndOfWeek with Day.Tuesday as second parameter (which is the start of the week).

Example query:

```let
Source = #table(type table[Date = date],List.Zip({List.Dates(#date(2017,12,1),31,#duration(1,0,0,0))})),
#"Calculated End of Week" = Table.TransformColumns(Source,{{"Date", each Date.EndOfWeek(_,Day.Tuesday), type date}})
in
#"Calculated End of Week"```

You may also be interested in Bemint - Power Query (M) Functions Dashboard.

Happy holidays!

Specializing in Power Query Formula Language (M)
Post Patron

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

Community Champion

II guess you mean a calculated column?

Something like:

`NextMonday = DATEADD(Dates[Date],MOD(7-WEEKDAY(Dates[Date],3),7),DAY) `
Specializing in Power Query Formula Language (M)
Post Patron

That´s it. Thank you.

Happy Holidays.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors