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 |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |