Power Query has a easy manner of calculating the age. Below is the DimCustomer desk from AdventureWorksDW desk which as a birthdate column. I even have eliminates a number of the greater columns to make it simpler to read;
To calculate the age of every customer, all you want is to:
In Power BI Desktop, Click on Transform Data
In Power Query Editor window; choose the Birthdate column first
visit Add Column Tab, below “From Date & Time” section, and below Date, choose Age
1
0 reads
Read & Learn
20x Faster
without
deepstash
with
deepstash
with
deepstash
Personalized microlearning
—
100+ Learning Journeys
—
Access to 200,000+ ideas
—
Access to the mobile app
—
Unlimited idea saving
—
—
Unlimited history
—
—
Unlimited listening to ideas
—
—
Downloading & offline access
—
—
Supercharge your mind with one idea per day
Enter your email and spend 1 minute every day to learn something new.
I agree to receive email updates