Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have this measure in DAX which works absolutely fine. I want this to be in Power Query, please help:
Week Offset =
Var StartOfWeek = 'Calendar'[Date] - WEEKDAY( 'Calendar'[Date], 2)+1
Var StartOfCurrentWeek = TODAY() - WEEKDAY(TODAY(), 2)+1
Return (StartOfWeek - StartOfCurrentWeek)/7
Thanks much
Solved! Go to Solution.
Hi @mb0307
Add a Custom column with this code in Power Query:
(Date.StartOfWeek([Date])-Date.StartOfWeek(DateTime.Date(DateTime.LocalNow())))/7
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
I have looked for this week offset everywhere. I was having a hard time figuring how to set it up. Thank you. Your solution really helped.
Great solution. To set the right datatype in one line use this.
= Table.AddColumn(Previous_M_Query_Step, "Name_Column", each
(Number.From((Date.StartOfWeek([Datum])-Date.StartOfWeek([Huidige_Datum]))/7)),Int64.Type)
Hi @mb0307
Add a Custom column with this code in Power Query:
(Date.StartOfWeek([Date])-Date.StartOfWeek(DateTime.Date(DateTime.LocalNow())))/7
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Excellent solution, do you know how to change the number to be a whole number all within the same formula? Just to take out the the time zeros from the number
nevermind, i figured out. Was simple. Just add a data type in the custom column section.
Worked perfectly. Thanks
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |