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 widely used language used in numerous calculations in Power BI, a lot of people do not know about the feature available in Power Query. In this blog , I'll explain how easy it is to calculate Age in Power BI and Power BI. This method is highly beneficial when your age calculation can be done on a pre-calculated row to row basis. Calculate Age from a date Below is the DimCustomer table from the AdventureWorksDW table which serves as the birthdate column. I've eliminated columns that aren't necessary so that it is easier to understand. For you to calculate your age for each consumer the only thing you'll need is: In Power BI Desktop, Click on Transform Data In the Power Query Editor window; start by selecting the Birthdate column. click on the Add Column Tab, and choose the "From Date & Time" section...