Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . But, since DAX is the most used language used in numerous computations in Power BI, many are unaware of this function in Power Query. In this blog post I will demonstrate how simple it is to calculate Age within Power BI and Power BI. This method is exceptionally beneficial in situations where you need for calculate the calculations of age can be performed by calculating the row-by-row basis. Calculate Age from a date Here is the DimCustomer table that is part of the AdventureWorksDW table, which is the birthdate column. I've removed some of the columns that aren't needed for clarity; In order to calculate the approximate age of each client will be, all you'll have to do is to: In Power BI Desktop, Click on Transform Data In the PowerQuery Editor window select the column that is the primary one, birthdate. Select the Add Column Tab next to