- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 in two separate cells in Excel to refresh my query. I imported the start date as a named range 'FromYTD' and saved as connection only. Then applied to the column as below.
Both the transactions column and From YTD is formatted as Date.
The error message I am getting is below. Please help. Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Brilliant! It worked. Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-14-2024 10:59 AM | |||
Anonymous
| 03-15-2023 11:15 AM | ||
11-15-2023 09:51 AM | |||
Anonymous
| 03-21-2024 08:15 AM | ||
05-23-2024 10:14 AM |
User | Count |
---|---|
32 | |
19 | |
14 | |
11 | |
10 |