Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple way in calculating the age . However, since DAX is the main language used in numerous calculations in Power BI, many are not aware of the functions available in Power Query. In this blog , I'll discuss how easy to calculate Age in Power BI using Power BI. This method is extremely useful in situations where your Age calculation can be carried out in a pre-calculated row rows. Calculate Age from a date Below is the DimCustomer table from the AdventureWorksDW table that functions as the "birthdate" column. I've removed the columns that don't have any value for the sake of making it easier to comprehend. To calculate your average age of each consumer All you need to do is to: In Power BI Desktop, Click on Transform Data In the Power Query Editor window; start by selecting the column titled Birthdate. Click on the Add Column Tab, and follow"Add Column" and ...