creating an age dimension, rounding issue when dividing months by 12

[wilson_smyth]

I am creating an Age Dimension. Granularity is months, so i have started by creating a column called TotalMonths, between 1 - 1440, which equates to 120 years.

I now want to add a year column. I thought totalMonths/12 would work, but on month 6, the year rounds up to 1. The year should only round up after 12.

Is there a way to do this in dax?

[Greg_Deckler · Accepted solution]

Try:
Column = INT([Value] / 12) + 1