How do we filter source data for the current year using dynamical filter in M query in Power BI.

[Anonymous]

Hello,

Need help on filtering the source data to the current year only. Basically I need dynamic filter to filter 2021 data into the report. Going forward 2022 data and so on. Below are the 2 date columns available in the source data.

Thanks in Advance.

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

Add a Filter step in Power Query Editor to let your data model only show values in current year.

Code:

...
...
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Year] = Date.Year(DateTime.LocalNow())))
in
    #"Filtered Rows"

Result:

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.