Forum Discussion
Date search
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
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
4 Replies
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 CommunityThank you for your help, that's perfect.
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!
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
