Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . However, since DAX is among the used language used in numerous calculations in Power BI, many do not realize this function in Power Query. In this blog post , I will explain how simple you can calculate Age in PowerBI using PowerBI. This method is very helpful in situations where you need for calculate the age calculations can be done on a row-by row basis. Calculate Age from a date Here's the DimCustomer table that's part of the AdventureWorksDW table, which is the birthdate column. I've removed some of the columns that aren't necessary in order to make it more user-friendly; To calculate the average age of every client must be, all you must do is to: In Power BI Desktop, Click on Transform Data In the PowerQuery Editor window select the first column, Birthdate. Go to the add Column Tab, then under "From Date & Time" sect...