Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . However, since DAX is the largest and most widely used language used in numerous calculations in Power BI, many do not realize this function in Power Query. In this blog post , I will describe how simple for you to calculate Age using Power BI in Power BI. This method is exceptionally helpful in situations where you need in order to calculate the age calculations can be carried out by calculating the row-by-row basis. Calculate Age from a date Here's the DimCustomer table, which is part of the AdventureWorksDW table which contains the birthdate column. I've removed a few columns that don't need to be there for clarity; In order to calculate how old every client will be, all you'll need to do is: In Power BI Desktop, Click on Transform Data In the PowerQuery Editor window, select the first column, Birthdate. Click on the Add Column Tab f...