Calulate months open but considers dates with end dates and those with none

[KossithAz]

Hi folks,

Looking at a dataset where I'm trying to work out the duration of months open from the start date.

Example:

Start date	End date	Months Open
05 December 2023	10 December 2023
06 May 2022	01 April 2023
07 November 2022

I was previously using 

Months open = DATEDIFF('inYear'[Start date],TODAY(),MONTH)

But sadly this keeps adding months onto those that have ended.

So ideally, I need the months since the start date, but stops for those with an end date and continues on for those without an end date.

[DOLEARY85 · Accepted solution]

Hi,

try something like this:

Months Open = IF( ISBLANK('inYear'[End date]), DATEDIFF('inYear'[Start date], TODAY(), MONTH), DATEDIFF('inYear'[Start date], 'inYear'[End date], MONTH) )

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[KossithAz]

Thank you, that has worked wonderful!