Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple way to calculating the age . However, since DAX is the preferred language in several researches in Power BI, many don't know about the functions available in Power Query. In this post, I'm going to describe how simple it is to calculate Age in Power BI using Power BI. This method is very effective in cases where the age calculation can be carried out using a row-by-row basis. Calculate Age from a date The table is DimCustomer table that comes from the AdventureWorksDW table which includes an age column. I've removed several of the extra columns to make it more readable; If you want to calculate the number of years of age for each customer, all you have to do is to: In Power BI Desktop, Click on Transform Data In the PowerQuery Editor window, choose the first column, Birthdate. Click on the Add Column Tab. Under "From Date & Time" section, and then under Date...