Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . However, since DAX is the most popular language used in several functions in Power BI, many are unaware of this function in Power Query. In this article I'm going to teach you how to calculate Age in Power BI with Power BI. This method is very useful in situations where you need to calculate the computation of an age can be done as an earlier calculated row by row basis. Calculate Age from a date The table below is DimCustomer table in the AdventureWorksDW table which as a birthdate column. I have removes some of the extra columns to make it more readable; To calculate your age for each buyer, you have to do is: In Power BI Desktop, Click on Transform Data In Power Query Editor window; start by selecting the Birthdate column. Click on the add Column Tab, then under "From Date & Time" section, and under Date, choose the age range....