Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . However, as DAX is the most popular language in many analysis in Power BI, many don't know about the functions available in Power Query. In this blog , I'm going to show you how simple it is to calculate Age in Power BI using Power BI. This method is highly effective when the age calculation can be performed using a row-by-row basis. Calculate Age from a date It's the DimCustomer table in the AdventureWorksDW table, which has the birthdate column. I've removed some of the columns that aren't needed to make it easier to read; If you wish to calculate the age of every customer the only thing you need do is: 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. Under the "From Date & Time" section, and then under Date select the age ...