Dax help

powerbidev123 Multiply by 1.

Age = YEAR(UTCNOW())- ( MID('Application'[Date of Birth],7,4) * 1 )

Wrap the MID with VALUE() to convert the text to a number:

Age = YEAR(UTCNOW()) - VALUE(MID('Application'[Date of Birth], 7, 4))

INT() also works, but VALUE is the more idiomatic choice when the string is a plain number.

One heads up: if [Date of Birth] is actually a date column you can skip MID entirely and just use YEAR('Application'[Date of Birth]). Also bear in mind this returns a rough age based on year only, without checking whether the birthday has passed this year.

If this helped, a thumbs up and accepting the solution would be appreciated.

Thanks,
Shai Karmani

Let's connect in LinkedIn