Forum Discussion
Filter by date in source step
Hi Everyone,
Would it be possible to filter by date in the source settings within the Power Query editor?
I currently have setup an extra step that filters all records to only show data which is after 1-1-2020 but if possible i would like to apply this filtering in the Source step already because I think that would be better for performance reasons.
Is this possible and how would my query look like?
In Advanced Editor: #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Period.Date Value] > #date(2020, 1, 1)),
You can use a DAX to filter data before importing. This has been solved here
Hi Gerald23 ,
You could also create the paremeters for filtering.
About more details, please kindly refer to
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
You can use a DAX to filter data before importing. This has been solved here
Hi Gerald23 ,
You could also create the paremeters for filtering.
About more details, please kindly refer to
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.