Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . However, because DAX is the most used language used in numerous computations in Power BI, many do not have any idea about this feature of Power Query. In this blog, I will explain how simple the process is calculate Age in Power BI with Power BI. This method is very helpful for situations in which you require be able to calculate the computations of age can be carried out by calculating the row-by-row basis. Calculate Age from a date Here's the DimCustomer table that's included in the AdventureWorksDW table and is the birthdate column. I've removed a few columns that weren't needed to make it easier to read; To calculate the age of each client is, all you'll need to do is: In Power BI Desktop, Click on Transform Data In the Window of the Power Query Editor; select the first column. birthdate. To add a column, click on the Column Tab...