Forum Discussion

jesly_ajin's avatar
jesly_ajin
Helper III
4 years ago

Dynamic from date and to date in web source query

Hi All,   In the below code, I need the bold ones to read data based on user selection of start and end date. Kindly guide me to achieve this.   let Source = Json.Document(Web.Contents("https:/...
Need Help
Show and Tell
jesly_ajin's avatar
jesly_ajin
Helper III
4 years ago

A slicer date drop down so that user can select.. 

I have created 2 tables for start date & end date using Create table option.

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    Convert those tables in lists and use List query in parameters. That way users can select dates as per their need. 

    Parameters gives following and you need to select last one. You will need to create 2 parameters like this - One for Start and one for End.

    Any Value   You can enter any value of any data type in the parameter query.
    List of Values    You can limit the values to a specific list by entering them in the small grid. You must also select a Default Value and a Current Value below.
    Query   Select a list query, which resembles a List structured column separated by commas and enclosed in braces.

    • jesly_ajin's avatar
      jesly_ajin
      Helper III
      4 years ago

      I did create the parameters and even list query for a column. but after doing that I am getting error.

      Any other suggestion.

       

      • Vijay_A_Verma's avatar
        Vijay_A_Verma
        Most Valuable Professional
        4 years ago

        Please post the error screenshot. Also, if possible you can post pbix file without data (remove any sensitive information like password etc in that).