Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . But, because DAX is the largest and most commonly used language used in numerous calculations in Power BI, many are unaware of this feature in Power Query. In this blog post I will demonstrate how simple for you to calculate Age using Power BI in Power BI. The method is extremely helpful for situations in which you require be able to calculate the calculation of age. can be made on a previously calculated row-by -row basis. Calculate Age from a date Here is the DimCustomer table, which is one of AdventureWorksDW table which contains the column for birthdates. I've removed some of the columns that don't need to be there for clarity; To calculate the age of each client is, all you need to do is: In Power BI Desktop, Click on Transform Data In the Power Query Editor window; choose the first column, Birthdate. To add a column, click on the Column T...