Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
Can anyone help me, Is there any way in Power Query to filter the table on date column from last/recent "Tuesday"?
As per my reqirement, I have to show data from last tueday.
Thanks in advance.
Solved! Go to Solution.
@Anonymous , These two will give you that, use that to filter the data
Date.AddDays(Date.StartOfWeek(Date.From(DateTime.FixedLocalNow()), 2),-7)
Date.StartOfWeek(Date.From(DateTime.FixedLocalNow()), 1)
@Anonymous , These two will give you that, use that to filter the data
Date.AddDays(Date.StartOfWeek(Date.From(DateTime.FixedLocalNow()), 2),-7)
Date.StartOfWeek(Date.From(DateTime.FixedLocalNow()), 1)
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |