Limit Exchange Connector to specific Dates

[spokrie]

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 way to limit the extract.

Am I missing something?

Thanks,

Scott

[parry2k · Accepted solution]

here is an example http://satalyst.com/power-query-creating-a-parameterized-function-in-m/

[blackwater]

I'm facing the same problem - but original page with solution is missing. Could you please share the solution?

[Anonymous · Accepted solution]

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

[parry2k · Accepted solution]

here is an example http://satalyst.com/power-query-creating-a-parameterized-function-in-m/