Age Calculation in Power BI using Power Query

Power Query has a simple way of calculating the age. However, because DAX is the popular language in many calculations in Power BI, many are not aware of this function in Power Query. In this video, I am going to show you how easy is to calculate Age in Power BI using Power BI. This method is very useful when the age calculation can be done as a pre-calculated row by row basis.
Read my blog article for more details and links to study more:

[PLBL]

Hey. What if you have a date slicer on your dashboard and you need the age at a point in time? (e.g. I select the year 2013 and want to see their age distributions then). This method only gives the age they are right now.

[tjiss]

So useful especially for beginners of powerbi

[ssma]

Another interesting tutorial! Thanks Reza🙏

[pieterjdw]

Thanks! How would you create a frequency representation of the age. Would be even beter if you present it in age brackets

[mohammadaamirkhan]

Sound Interesting!
Thanks for making an insightful video.

[charlusmissier]

Thanks a lot. The video solved a huge question I had

[stephaniewilson]

Just what I need to know...thank you!!

[charlenemarch]

WOW this was a Huge time saver. Thank you! great video.

[sharatbabu]

Hi Sir, can u tell how can we calculate the upcoming birthdays in current week and next week.

[PLBL]

Hey! What if you need the age to calculate dynamically based on a slicer on your dashboard. For example you have a slicer which changes the financial year of your report, and you have a graph showing age brackets of your workforce or something like that. You need the calculation find their age in that financial year, not their age today.

[isranim]

How to write query when you have to calculate ageing in days... For example there is a "Last working date" Is blank, and you have "date of joining"

Like we write in excel = if(lwd) = "", today() - (doj), (lwd) -(doj)

Similarly I have to find out the number of days people spent at workplace.

[krishanakarmogili]

I looking to group the age into 3 categories like <40 40-60 and >60, could you please share the link if you have

[ashoklingutla]

How to calculate age in direct query mode

[mathew]

As you note in a reply to Peter's comments - Do you have a solution that correctly deals with Date of Birth age calculations and the Leap Year issue?

[isranim]

How can we put this age slab... Say 0 to 20 has 2 people, 20+ to 40 has 4 people etc

[akramhemmat]

Hi Dear, I need Formula for deferent ages E.g. : 0-5, 6-18, 19-49, 50-60, 60-70, I need this formula to add it in the custom column when I am adding new custom column. Thanks.