Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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