Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
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.
Brilliant! It worked. Thanks
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
8 | |
7 | |
6 |