Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Kkaushik
Frequent Visitor

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.

Kkaushik_2-1653980914824.png

 

 

Kkaushik_0-1653980596034.png

Both the transactions column and From YTD is formatted as Date.

The error message I am getting is below. Please help. Thanks

Kkaushik_1-1653980646492.png

 

1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

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. 

View solution in original post

2 REPLIES 2
Kkaushik
Frequent Visitor

Brilliant! It worked. Thanks

Vijay_A_Verma
Super User
Super User

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

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors