Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple way in calculating the age . However, as DAX is the most used language used in numerous calculations in Power BI, many do not know about the function available in Power Query. In this blog article I'll explain how easy it is to calculate Age in Power BI with Power BI. The method is extremely helpful when your age calculation can be performed on a pre-calculated row by row basis. Calculate Age from a date Below is the DimCustomer table from the AdventureWorksDW table that acts as the birthdate column. I've removed the columns that aren't needed to make it easier to read. For you to calculate your age for each consumer, all you need is to: In Power BI Desktop, Click on Transform Data In the Power Query Editor window; start by selecting the Birthdate column. go to Add Column Tab, and then click on the "From Date & Time" section, and under Date, select Age ...