Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple way that is a simple method of calculating the age . However, as DAX is the most widely used language used in several calculations in Power BI, many are unaware of the functions available in Power Query. In this blog article , I'll describe how simple for you to calculate Age for PowerBI using PowerBI. It is a method is very useful when you need to do the age calculation. It can be calculated using an earlier calculated row by row basis. Calculate Age from a date That's what's in the DimCustomer table . This is part of the AdventureWorksDW table that acts as the column for birth dates. I've removed the columns that don't need to be there for clarity; To calculate how old you are for each customer, you will need: In Power BI Desktop, Click on Transform Data In the PowerQuery Editor window; make sure that you select the first column, namely the Birthdate. Go to the ...