Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple way in calculating the age . However, because DAX is the most commonly used language used in numerous calculations in Power BI, many do not have a clue about the option available within Power Query. In this blog post I'll discuss how easy to calculate Age in Power BI with Power BI. The method is exceptionally useful in situations where your age calculation can be made on a pre-calculated row by row basis. Calculate Age from a date This is the DimCustomer table from the AdventureWorksDW table that functions as the birthdate column. I've removed columns that aren't required for ease of understand. To calculate your average age of each consumer all you have to do is: In Power BI Desktop, Click on Transform Data On the Power Query Editor window; start by selecting the column titled Birthdate. go to Add Column Tab, and select"Add Column" and then on "From Date ...