Age Calculation in Power BI using Power Query Power Query has a simple method of calculating the age . However, because DAX is the preferred language used in many calculations in Power BI, many don't know about this feature provided by Power Query. In this article, I'll describe how easy it is to calculate Age in Power BI using PowerBI. It is a method is extremely efficient in cases where the estimation of your age can be performed on a pre-calculated rows and basis. Calculate Age from a date Below, you'll find the DimCustomer table which is part of the AdventureWorksDW table. It also has an entry for birthdates. I've removed several of the columns that don't need to be for ease of read; To calculate the time of each customer's purchase all you need to do is: 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 then select"Add...
Comments
Post a Comment