Forum Discussion
Solved
Limit Exchange Connector to specific Dates
I'd like to pull data from my Exchange Calendar, but I'd like to limit it to a specific date range. Say something like FY2017. Other than pulling the whole calendar then filetering I don;t see a wa...
Hi spokrie,
parry2k's solution seems well, you can also use Table.SelectRows function to achieve your requirement.
Add step to filter row.
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each Date]= "FY2017")
In addition, you can also use parameter to instead the static value, then you can modify the filter value at report view side.
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each Date]= FilterDate)
Notice: FilterDate is a parameter which created in query editor.
Regards,
Xiaoxin Sheng
I'm facing the same problem - but original page with solution is missing. Could you please share the solution?