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, many don't know about the functionality available in Power Query. In this blog post I'll explain how easy it is to calculate Age in Power BI and Power BI. This method is very beneficial when you need to calculate your estimation of your age can be carried out on a pre-calculated row by row basis. Calculate Age from a date Below is the DimCustomer table that is part of the AdventureWorksDW table which serves as the "birthdate" column. I've removed columns that aren't needed to make it easier to read. 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 choosing the Birthdate column. Go to the Add Column Tab, follow"Add Column." Then, cl...