October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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.
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |