Forum Discussion
Match Between Dates
Hello,
I'm trying to extract an amount between two dates when matched to another data set.
E.g.
Create a new column / merge the data by date so that any date can pull one of the "Amounts" below.
If I have a date of 6/1/2024 it would match $850 for Carrier B;
If I have a date of 6/1/2025 it would pull a value of $300 for Carrier C
| As Of | Carrier | Amount |
| 1/1/2022 | A | $500.00 |
| 1/1/2022 | B | $850.00 |
| 1/1/2022 | C | $250.00 |
| 1/1/2022 | D | $600.00 |
| 1/1/2025 | A | $100.00 |
| 1/1/2025 | B | $200.00 |
| 1/1/2025 | C | $300.00 |
| 1/1/2025 | D | $400.00 |
5 Replies
Hi hisackman ,
If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.
We value your feedback, and it will help us to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Fabric Community Forum.
Hi hisackman,
If the information provided by @Ashish_Excel Irwan is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help
Thank You!!
