Forum Discussion
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 till date
| dateKey | date | DOWInMonth | DayOfYear | WeekOfYear | WeekOfMonth | Month | MonthName | Quarter | QuarterName | Year | hourGroupKey |
| 2027010804 | 1/8/2027 | 2 | 8 | 2 | 2 | 1 | January | 1 | First | 2027 | 1 |
| 2016010805 | 1/8/2016 | 2 | 8 | 2 | 2 | 1 | January | 1 | First | 2016 | 1 |
| 2009010602 | 1/6/2009 | 2 | 8 | 2 | 2 | 1 | January | 1 | First | 2009 | 1 |
Thanks in Advance
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
2 Replies
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
Thanks Ever, it work for now in Power Query Editor I need to create a DAX measure if you can help it will be great , permenant fix in reports as i have only read access to SQL i need create in Power BI report ( i used this one DATESBETWEEN(<dates>,<start_date>,<end_date>) ) but it did work