Age Calculation
Age Calculation in Power BI using Power Query Power Query has a simple method of calculating the age . However, since DAX is the most popular language used in several calculation in Power BI many are unaware of this feature in Power Query. In this blog post I will discuss how easy it is to calculate Age in Power BI with Power BI. The method is extremely beneficial in cases where the calculation of an age can be completed in a row-by-row basis. Calculate Age from a date That's the DimCustomer table that is part of the AdventureWorksDW table which contains a birthdate column. I've removed some the columns that aren't required for clarity; For you to calculate an age for every buyer, you will need: In Power BI Desktop, Click on Transform Data In the Power Query Editor window, start by selecting the Birthdate column. Click on the Add Column Tab. Under the "From Date & Time" section, and then under Date Choose the age range. It...

Comments
Post a Comment