Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method for calculating the age . But, because DAX is the primary language used in numerous computations in Power BI, many are not aware of this function in Power Query. In this article I'll explain how easy it is to calculate Age in Power BI using Power BI. This method is extremely beneficial in situations where your estimation of the age can be done as an earlier calculated row by row basis. Calculate Age from a date Below you can see the DimCustomer table that is part of the AdventureWorksDW table that acts as the birthdate column. I've removed a few of the extra columns to make it easier to read. In order to calculate your age for each customer, all you need is to: In Power BI Desktop, Click on Transform Data In Power Query Editor window; pick the Birthdate column first. go to add Column Tab, and then click on the "From Date & Time" section, and under Da...