Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |