cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Calculate last 90 days data using Table.SelectRows

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

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Highlighted
Super User
Super User

Re: Calculate last 90 days data using Table.SelectRows

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

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!