Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . However, as DAX is one of the well-known language used in numerous calculations in Power BI, many don't know about this feature available in Power Query. In this blog post , I will show how easy you can calculate Age within Power BI using Power BI. This method is very beneficial when you have for calculate the age calculations can be done using a calculated row-by-row basis. Calculate Age from a date Here's the DimCustomer table, which is an element of the AdventureWorksDW table that is the column for birthdates. I've removed a few columns that aren't necessary to make it easier to read; To calculate the age of each client is, all you need to do is to: In Power BI Desktop, Click on Transform Data In the Power Query Editor window, select the first column, birthdate. Click on the Add Column Tab and then click on the "From Date & ...