Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi, I have a date table that I always want to filter to yesterday on a refresh. How to I adjust the M code to make this happen?
= Table.SelectRows(#"Changed Type2", each [DateKey] <= #date(2018, 4, 10))
Many thanks in advance.
Solved! Go to Solution.
is this what you mean?
https://msdn.microsoft.com/en-us/query-bi/m/date-adddays
Date.AddDays(DateTime.FromText("2011-12-31"), -1)
Proud to be a Super User!
is this what you mean?
https://msdn.microsoft.com/en-us/query-bi/m/date-adddays
Date.AddDays(DateTime.FromText("2011-12-31"), -1)
Proud to be a Super User!
Thank you, it was close to what I wanted. I ended it with
= Table.SelectRows(#"Changed Type2", each [DateKey] < DateTime.Date(DateTime.LocalNow()))
And it did the trick.. 🙂
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
86 | |
67 | |
49 |
User | Count |
---|---|
135 | |
113 | |
100 | |
68 | |
67 |