Age Calculation in Power BI using Power Query Power Query has a simple method of calculating the age . However, because DAX is the most popular language used in many computations in Power BI, many do not understand this capability of Power Query. In this blog , I'll describe how simple to calculate Age in Power BI with PowerBI. This method is very efficient when the estimation of the age can be performed on a pre-calculated row and on a row basis. Calculate Age from a date Below you can view the DimCustomer table that comprises the AdventureWorksDW table. It has the birthdate column. I've removed several of the columns which aren't needed in order to make it easier for you to comprehend; To calculate the actual 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; start by choosing the column with the birthdate. Go to the Add Column Tab, then click on"...
Comments
Post a Comment