Forum Discussion
Calculate last 90 days data using Table.SelectRows
Hi,
How to extract data for last 90 days based on current date from a sql server table in advanced editor? I want to Table.SelectRows and apply last 90days condition.
Looking for solution
Dealing with dates in M can be kind of a pain. I would suggest that you just write the appropriate SQL query to do it. Something like:
SELECT * FROM Orders WHERE OrderDate>=DATEADD(DAY,-90,CONVERT(date,GETDATE()))
May or may not need the CONVERT. GETDATE gets the current date time and DATEADD will subtract 90 days from that.
If you REALLY want to do it in M code, here is a thread that should get you there:
https://community.powerbi.com/t5/Desktop/Power-Query-Current-Date-Filter/td-p/67586
1 Reply
Dealing with dates in M can be kind of a pain. I would suggest that you just write the appropriate SQL query to do it. Something like:
SELECT * FROM Orders WHERE OrderDate>=DATEADD(DAY,-90,CONVERT(date,GETDATE()))
May or may not need the CONVERT. GETDATE gets the current date time and DATEADD will subtract 90 days from that.
If you REALLY want to do it in M code, here is a thread that should get you there:
https://community.powerbi.com/t5/Desktop/Power-Query-Current-Date-Filter/td-p/67586