Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple way for calculating the age . However, because DAX is the preferred language in various researches in Power BI, many are unaware of the function available in Power Query. In this post, I'm going to describe how simple it is to calculate Age in Power BI through Power BI. This method is highly effective when Age calculation can be performed on a previously calculated row-by - row basis. Calculate Age from a date It's the DimCustomer table that comes from the AdventureWorksDW table, which has the birthdate column. I've removed a few of the columns that aren't needed in order to make it easier to read; If you want to calculate the amount of time each customer has been in the market, all you have do is: In Power BI Desktop, Click on Transform Data In Power Query Editor window, select the first column, Birthdate. Click on the Add Column Tab. Under "From Date & Time...