Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . However, as DAX can be the most commonly used language used in numerous computations in Power BI, many do not realize this feature available in Power Query. In this blog, I will show how easy you can calculate Age within Power BI with Power BI. This method is very useful when you need to calculate the computations of age can be performed on an already calculated row-by-row basis. Calculate Age from a date Here's the DimCustomer table that is one of AdventureWorksDW table and is the birthdate column. I've eliminated some columns that weren't needed to make it more readable; In order to calculate the age of each client, the only thing you have to do is to: 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 Tab Then, under the "From Date ...