Solved: Re: Limit Exchange Connector to specific Dates

spokrie · ‎01-05-2017

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 · ‎01-05-2017

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

Anonymous · ‎01-08-2017

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