Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method to calculating the age . However, as DAX is the most used language used in numerous computations in Power BI, many do not know about this feature available in Power Query. In this blog post I will show how easy you can calculate Age in Power BI using Power BI. The method is exceptionally beneficial in situations where you need for calculate the calculations of age can be made on a row-by row basis. Calculate Age from a date Here is the DimCustomer table that's one of AdventureWorksDW table which includes the birthdate column. I've removed columns that aren't needed in order to make it more user-friendly; In order to calculate the average age of every client has reached, the only thing you'll need to do is: In Power BI Desktop, Click on Transform Data In the Power Query Editor window, select the first column. birthdate. Go to the add Column Tab next to the ...