Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . However, since DAX is the most popular language used in numerous computations in Power BI, many do not have any idea about this feature within Power Query. In this blog post , I will describe how simple you can calculate Age with PowerBI using PowerBI. The method is extraordinarily helpful for situations in which you require for calculate the calculations of age can be made on a row-by row basis. Calculate Age from a date Here's the DimCustomer table that's part of the AdventureWorksDW table that is the column for birthdates. I've removed some of the columns that aren't necessary to make it easier to read; To calculate the age of each customer has reached, the only thing you'll have to do is: In Power BI Desktop, Click on Transform Data In the Power Query Editor window, select the first column. birthdate. Go to the add Column Tab fi...