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 do not realize this feature to Power Query. In this blog article I'll show you how easy it is to calculate Age in Power BI using PowerBI. This method is extremely efficient when the estimation of your age can be calculated on a pre-calculated row or row basis. Calculate Age from a date Below you can view the DimCustomer table, which makes up the AdventureWorksDW table. It also has a birthdate column. I've removed several of the columns which aren't needed for ease of be read In order to calculate the actual age of each buyer, the following information is required: 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, then click on"Add Column". Then...
Comments
Post a Comment