Forum Discussion

Amzad's avatar
Amzad
Frequent Visitor
8 years ago
Solved

Between Years from 2016 till date

 I have a Table which has data  from 2009 to 2030 (2030 its not rite)      Source data from SQL                                                                i need to show only  years from 2016 to ...
  • Whatever2's avatar
    8 years ago

    Do you get tour data from a SQL query ? if so you can use something like this in your where clause :

    mydate between ('2016',year(getdate()))

    otherwise you can try to filter in the header of the Power Query editor