Join us in Las Vegas on June 13-16 for the Snowflake Summit # How to calculate age in Tableau workbook?

• Tableau FAQs
• December 13, 2018

To calculate age in Tableau, you need to use the date functions. So, for example, to solve this problem, we can use the DATEADD and DATEDIFF functions. The first function is used to add a certain number of days, months, etc., to the current date. The second function calculates the interval between two dates. This is a powerful combination of functions, and it will help calculate not only age but also any interval between two dates.

``````IF DATEADD('year', DATEDIFF('year', [Birthday], TODAY()), [Birthday])> TODAY()
THEN

DATEDIFF('year', [Birthday], TODAY())-1

ELSE

DATEDIFF('year', [Birthday], TODAY())

END``````

#### What is this expression doing?

IF DATEADD(‘year’, DATEDIFF(‘year’, [Birthday], TODAY()), [Birthday])> TODAY(), – in this part of the expression, we add the years that we calculate from the difference between the date of birth and today

THEN

DATEDIFF(‘year’, [Birthday], TODAY())-1 since we are using the IF function to check the correct age display. since at the time of calculations, the birthday may not yet come. then we subtract one year so that the data is displayed correctly
ELSE

DATEDIFF(‘year’, [Birthday], TODAY())

END if the expression is incorrect, then we just display the age

That is how to calculate age in Tableau using the DATEDIFF expression.

## From 1 Week to 1 Hour!

### No-Code Data Transformation

Model data directly in your Snowflake instance with easy-to-use functions and visual workflows

## More Resources We Think You Might Like

### How can I increase the size of the pie chart wi...

When you create a Pie Chart, you can resize the circle using the image’s functionality. But...

• Tableau FAQs
• December 11, 2018

### Power BI and Tableau: A Comparison

Salesforce’s Tableau and a Microsoft Product Power BI have emerged as two leading players in the ...

• Benoite Yver
• January 11, 2020

### How do I write a Case Statement With Multiple C...

I have two conditions using separate fields, but Tableau won’t let me write it as I would l...

• Tableau FAQs
• December 13, 2018