Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method of calculating the age . However, as DAX is the most widely used language used in numerous calculations in Power BI, a lot of people are not aware of the functionality available in Power Query. In this blog post, I'll discuss how easy to calculate Age in Power BI with Power BI. This method is highly beneficial in situations where your calculations of age can be made using a pre-calculated row rows. Calculate Age from a date This is the DimCustomer table from the AdventureWorksDW table that serves as the "birthdate" column. I've removed columns that don't have any value in order to make it easier to study. To calculate your age for each person all you have to do is to: In Power BI Desktop, Click on Transform Data In the Power Query Editor window; begin by selecting the Birthdate column. click on the Add Column Tab, and select"Add Column", then se...