Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |