Calculate age from dob field and another date value using slicer

Question

How to calculate age from dob field and using slicer to choose current year?

Answer 1

Hi Karthick,

Create a parameter with year range as per data requirement.(ex: 2010-2018 and provide increment as 1)

Create a column as DATEDIFF([DOB],[Parameter-name],YEAR).

The above field would fetch the age or years.

Hope it helps.