Date search

[Daveh1983]

Hi all,

I'm very new to power query and wanted to ask for some help. I have columns in power query with start and end dates. What I want to do is if the date is within certain peramaters to bring back a number , for example 

If date is  in-between dates xxx  and xxx then value is x or if date is between xxx and xxx then value is y 

I know I'm probably being stupid but you guys seem to be the ones to ask

Many Thanks

[Syk · Accepted solution]

You can use a custom column to compare multiple values. It doesn't have a gui to help out but the logic should be pretty simple to follow. Check out this post which has similar requirements and an example.
Solved: Power query If submit date between start date and ... - Microsoft Power BI Community

[Daveh1983]

Thank you for your help, that's perfect. 

[Syk]

You can create a conditional column and set whatever parameters work for you. Without more information it's a bit tough to help further than that!

[Daveh1983]

Hi Syk,

Thanks for replying. I did look at conditional column however it appears to be just a single date rather then be able to select a date range which is what I need. (Apologies I didn't explain very well) 

I want to bring back a value for certain date ranges. Let's say between start date of 1/2/2023 and the end date of 1/3/2023 I want the value 12 to appear in the new column. If the date range falls between start date 1/4/2023 and the end date  1/5/2023 I want the value 20 to appear in the new column. 

Does that make more sense? Apologies for my poor explanation.

Cheers