Match Between Dates

[hisackman]

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

[Ashish_Excel · Accepted solution]

Hi,

Download PBI file from here.

Hope this helps.

[v-aatheeque]

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.

[v-aatheeque]

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!!

[v-aatheeque]

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.

[Irwan]

hello @hisackman 

in your example, since there is no other condition besides date, why it will take Carrier B on 6/1/24?

also why it takes Carrier C on 6/1/25?

Thank you?