Calculate future months amounts in buckets

[MP-iCONN]

I am trying to calculate future months Purchase Order Commitments as we call it.

In my table I have Vendor ID's, Required Dates, and Total Dollar amounts for those given Required Dates.

For example one vendor looks like this for the data:

Vendor ID	Required Date	Ext Amount
1068	6/13/2022	5254.40
1068	7/11/2022	6666.00
1068	7/20/2022	27900.00
1068	7/20/2022	3980.00
1068	7/20/2022	13000.00
1068	7/20/2022	2367.60
1068	8/4/2022	579.86
1068	8/8/2022	2367.60
1068	8/26/2022	3121.88
1068	8/26/2022	18854.37
1068	9/1/2022	12277.43
1068	9/7/2022	59208.33
1068	9/9/2022	5424.00
1068	10/6/2022	4509.78
1068	10/10/2022	3980.00
1068	11/1/2022	7230.00
1068	11/10/2022	7662.00
1068	11/16/2022	4500.00
1068	11/17/2022	15992.59
1068	11/17/2022	5948.25
1068	12/1/2022	2684.25
1068	12/15/2022	3980.00
1068	12/15/2022	4116.09
1068	12/15/2022	1507.29
1068	12/15/2022	15084.30
1068	12/31/2022	5155.20
1068	1/4/2023	3996.00
1068	2/2/2023	3996.00
1068	2/4/2023	2712.00

What I would like is to get all of these broken up into buckets (column measures).

What I have now is...

Past Due which is this measure:

Past Due = CALCULATE(SUM(OpenPOs[Ext Amount]), OpenPOs[Required Date]<TODAY())

Current Month which is this measure:

Current Month = CALCULATE(SUM(OpenPOs[Ext Amount]), DateTable[Now]="Current Month")

And I have Total Due which is the Sum of the Ext Amount.

I also wanted to have it month by month so have columns for each future month till the end of the year and then have a final measure of end of the year and beyond.

I have a Date Table that is a One to Many of my Required Dates that is in place as well.

Any advice on how to get this done is greatly appreciated.

[amitchandak · Accepted solution]

@MP-iCONN ,

Current Month = CALCULATE(SUM(OpenPOs[Ext Amount]), eomonth(OpenPOs[Required Date],0) =  eomonth(TODAY(),0) )

future months = CALCULATE(SUM(OpenPOs[Ext Amount]), eomonth(OpenPOs[Required Date],0) >  eomonth(TODAY(),0) )