Calculate last 90 days data using Table.SelectRows

[Anonymous]

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

[Greg_Deckler · Accepted 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