Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Amzad
Frequent Visitor

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  

dateKeydateDOWInMonthDayOfYearWeekOfYearWeekOfMonthMonthMonthNameQuarterQuarterNameYearhourGroupKey
20270108041/8/202728221January1First20271
20160108051/8/201628221January1First20161
20090106021/6/200928221January1First20091

 

Thanks in Advance 

1 ACCEPTED SOLUTION
Whatever2
Helper I
Helper I

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

View solution in original post

2 REPLIES 2
Whatever2
Helper I
Helper I

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                                                                            

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.