Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method of calculating the age . However, because DAX is the most popular language used in numerous calculations in Power BI, a lot of people do not have a clue about the feature available in Power Query. In this blog article I'll go over how simple to calculate Age in Power BI and Power BI. The method is extremely useful in situations where you need to calculate your age calculation can be performed in a pre-calculated row row basis. Calculate Age from a date Below is the DimCustomer table that is part of the AdventureWorksDW table that acts as the "birthdate" column. I've eliminated columns that don't have any value so that it is easier to study. For you to calculate your age for each person the only thing you'll need is: In Power BI Desktop, Click on Transform Data On the Power Query Editor window; start by selecting the column titled Birthdate. Click on t...