Calculate amount of contracts expiring in next 5 months

[GH21]

Hi All,

I'm keen to find an answer for a measure to calculate the amount of contracts expiring from today's date over to the next 5 months. 

Thank you in advance!

[v-shex-msft]

HI @GH21 

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If the above doesn't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

In addition, you can also try to use the following measure formula if helps:

ExpiringContracts =
VAR cDate = TODAY ()
RETURN
    CALCULATE (
        COUNT ( Table[ContractID] ),
        FILTER (
            ALLSELECTED ( Table ),
            [Date] >= cDate
                && [Date]
                    <= DATE ( YEAR ( cDate ), MONTH ( cDate ) + 5, DAY ( cDate ) )
        )
    )

Regards,

Xiaoxin Sheng

[ssethia91]

Try this

ExpiringContracts = CALCULATE(COUNTROWS(financials),DATESBETWEEN(financials[Date],today(),EOMONTH(TODAY(),5)))

[GH21]

Hi @Alf94 

Due to the sensitivity of the work, unfortunately I can't share data but in total there is 91 contracts expiring throughout 2023. Is it possible to calculate how many will expire over the next 5 months using the expiry dates?

[Alf94]

Hi @GH21 ,

Can you share some dummy data so that we can help you better?

Thank you,