Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
II guess you mean a calculated column?
Something like:
NextMonday = DATEADD(Dates[Date],MOD(7-WEEKDAY(Dates[Date],3),7),DAY)
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!
Thank you very much. But I was thinking of a measure.
II guess you mean a calculated column?
Something like:
NextMonday = DATEADD(Dates[Date],MOD(7-WEEKDAY(Dates[Date],3),7),DAY)
That´s it. Thank you.
Happy Holidays.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
84 | |
73 | |
49 |
User | Count |
---|---|
143 | |
131 | |
110 | |
64 | |
55 |