Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple way in calculating the age . But, since DAX is the most used language used in numerous calculations in Power BI, many are not aware of the functionality available in Power Query. In this blog , I'll explain how easy to calculate Age in Power BI with Power BI. This method is exceptionally beneficial in situations where you need to calculate your Age calculation can be carried out on a pre-calculated row by the row. Calculate Age from a date Here is the DimCustomer table that is part of the AdventureWorksDW table that serves as the "birthdate" column. I've removed the columns that don't need to be there for ease of read. For you to calculate your age for each person All you need to do is: In Power BI Desktop, Click on Transform Data In the Power Query Editor window; start by choosing the column titled Birthdate. go to Add Column Tab, and select"Add Column...