Make A Formula With Dates.

Hi DouglasWatkins ,

According to your description, here's my solution.

1.Count distinct IDs in all the years. Create a measure.

Measure =
CALCULATE ( DISTINCTCOUNT ( 'Table'[ID] ) )

Result:

2.Count distinct IDs in each year. Create a measure.

Measure2 =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[ID] ),
    YEAR ( 'Table'[Dates] ) = YEAR ( MAX ( 'Table'[Dates] ) )
)

Result:

3.Count distinct IDs in each fiscal year. First create a calculated column.

FiscalYear =
IF ( MONTH ( [Dates] ) < 7, YEAR ( [Dates] ), YEAR ( [Dates] ) + 1 )

Then create a measure:

Measure3 =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[ID] ),
    'Table'[FiscalYear] = MAX ( 'Table'[FiscalYear] )
)

Result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.