none
How to filter the data based on user input? RRS feed

  • Question

  • Hi,

    I have the following data

    I want to have two calendar drop down where the user can choose the start date and the end date, the result should be filtered based on the user input.

    How can I achieve this using Power Query/Pivot/View?


    • Edited by Olivia127 Tuesday, January 5, 2016 6:39 AM
    Tuesday, January 5, 2016 6:39 AM

Answers

  • Got it. Using advanced filter in power view or 

    https://blog.oraylis.de/2013/05/using-dynamic-parameter-values-in-power-query-queries/

    • Marked as answer by Olivia127 Tuesday, January 5, 2016 10:20 AM
    Tuesday, January 5, 2016 10:20 AM

All replies