Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |