Forum Discussion

Kkaushik's avatar
Kkaushik
Frequent Visitor
4 years ago
Solved

Power Query Date Filters in Excel

Hello, I am very new to PQ. I have imported huge data from SalesForce. I want to apply 'from and to' date filters on 'transactions date' column but I want users to input the 'from' (and 'to') dates i...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    In your formula, make it FromYTD{0} in place pf FromYTD. This will make it refer to first value of FromYTD list.

    OR

    Don't change formula, in your FromYTD list, right click on List column and drill down. This will make it a single value and you query will work correctly. 

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

In your formula, make it FromYTD{0} in place pf FromYTD. This will make it refer to first value of FromYTD list.

OR

Don't change formula, in your FromYTD list, right click on List column and drill down. This will make it a single value and you query will work correctly.