Forum Discussion
Date search
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
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