Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple way to calculating the age . But, as DAX is the preferred language in several analysis in Power BI, many are not aware of the option available within Power Query. In this blog , I'm going to discuss how easy to calculate Age in Power BI by using Power BI. This method is highly efficient when the age calculation can be completed on a calculated row-by row basis. Calculate Age from a date The table is DimCustomer table in the AdventureWorksDW table, which has a birthdate column. I've removed a few of the extra columns for easier reading; If you're trying to calculate the age of each customer all you have to do is to: In Power BI Desktop, Click on Transform Data In the PowerQuery Editor window; pick the Birthdate column first. Click on the Add Column Tab. Under "From Date & Time" section, and under Date Choose the appropriate age range. That's all ther...