Calculating average units for two years

Hello, you should be able to use Measured Values for this.

In the widget, you can create a formula that is something like: ( DUPCOUNT([AccountId]), [Years in CreatedDate] )

And if you right-click [CreatedDate], you can apply a filter to select the appropriate year.  This can be combined as needed for a larger run rate formula.

----

Alternatively, in the ElastiCube, you could create yearly custom columns like this:

AccountCreated_2022 = CASE WHEN GETYEAR([CreatedDate]) = 2022 THEN 1 ELSE 0 END

AccountCreated_2023 = CASE WHEN GETYEAR([CreatedDate]) = 2023 THEN 1 ELSE 0 END

etc.

You could then SUM() those columns within the widgets to use 2022 or 2023 counts within formulas.  This logic could also be added to an import query directly, as opposed to creating custom columns.  But this all depends on the exact way that your data is laid out.