Forum Discussion
Between Years from 2016 till date
- 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
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
- Amzad8 years agoFrequent Visitor
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