Age Calculation

 <h2>

 <a href="https://lencis.net/">Age Calculation </a>in Power BI using Power Query

</h2>

<p>

 Power Query has a simple way in <a href="https://lencis.net/">calculating the age</a>. However, since DAX is the most used <a href="https://en.wikipedia.org/wiki/Language">language used</a>in several <a href="https://lencis.net/">calculation</a>in Power BI, many don't know about this function in Power Query. In this blog , I will demonstrate how easy it is to <a href="https://play.google.com/store/apps/details?id=com.google.android.calculator&hl=en_IN&gl=US">calculate</a>Age in Power BI with Power BI. The <a href="https://en.wikipedia.org/wiki/Method">method</a>is very beneficial when the <a href="https://lencis.net/">calculation of an age</a>can be conducted using a previously calculated row-by-row basis.

</p>

<h2>

 <a href="https://lencis.net/">Calculate Age from a date</a>

</h2>

<p>

 This is the DimCustomer table in the AdventureWorksDW table, which includes the birthdate column. I've removed some the columns that aren't required in order to make it easier to read;

</p>

<p>

 For you to calculate what is the average age each buyer, you will need:

</p>

<ul>

 <li>

  In Power BI Desktop, Click on Transform Data

 </li>

 <li>

  In the Power Query Editor window, start by selecting the Birthdate column.

 </li>

 <li>

  Click on the Add Column Tab. Under the "From Date &amp; Time" section, and under Date choose the date range.

 </li>

</ul>

<p>

 It's that simple. it. This will calculate the amount which is the sum in the Birthdate column as well as the current time and date.

</p>

<p>

 However, the date that appears in the Age column does not really appear like an age. That is because it is an actual time period.

</p>

<h2>

 Duration

</h2>

<p>

 Duration is a distinct form of data that is used for Power Query which represents the differences between the two DateTime values. Duration is the sum of four numbers:

</p>

<p>

 <em>

  <em>days.hours.minutes.seconds</em>

 </em>

</p>

<p>

 This is how you view the above information. However, for the perspective of an individual, you do not wish them to research information such as this. There are ways to get each portion that is an amount of time. If you select the Duration menu you'll notice that you can get the amount of seconds or minutes or hours, days, and years from it.

</p>

<p>

 For aid when calculating the age in years such as, for instance it is easy to select Total Years.

</p>

<p>

 Make note of the fact that the duration that the programme runs is calculated in days , and then divided into 365, providing you with an annual amount.

</p>

<h2>

 Rounding

</h2>

<p>

 And lastly, nobody claims they are 53.813698630136983! They call it 53, then they round it down. It's easy to choose the Rounding option and Round Down under the Transform tab.

</p>

<p>

 This will provide you with the age in years:

</p>

<p>

 Then, you can tidy other columns as you'd like (or perhaps you've taken advantage of transformations using the Transform tab to prevent creating of additional columns) This column may be renamed to Age column and Age:

</p>

<h2>

 Things to Know

</h2>

<ul>

 <li>

  <strong>Refresh</strong> The age that is calculated by this method will be updated every time you are refreshing your database. Each time, it will compare the birthdate to the date and time that the database refresh was made. This method is pre-calculating the age. If you're in need of this calculation performed dynamically with DAX, I've gave you a procedure you can apply.

 </li>

 <li>

  <strong>The motivation for Power Query</strong>: Benefits of doing age calculations using Power Query is that the calculation is carried out in the course of refreshing the report. The report is refreshed using an application that makes the calculation easier, and there's no added cost of doing it with DAX to calculate the runtime.

 </li>

 <li>

  Another case where these are not intended to be used to calculate age. They only begin at the date of birth. It could be used to calculate the age of inventory for products as well as for the variation of two date or times from one another.

 </li>

</ul>

<h2>

 Video

</h2>

<p>

 REZA RAD

</p>

<p>

 TRAINER, CONSULTANT, MENTORReza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He holds the BSc with a degree in Computer engineering. He holds the more than 20 years of experience in the fields of data analysis in BI, databases and programming primarily using Microsoft technologies. He has been an Microsoft Data Platform MVP for nine years in a row (from 2011 until today) for his dedication in the field of Microsoft BI. Reza remains an active writer and co-founder at RADACAD. Reza is also co-founder as well as organizer of Difinity Conference which is held in New Zealand.

 <br>

 His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

 <br>

 He has also written a few book concerning MS SQL BI and also is working on more books. Additionally, he is a regular participant on technical forums online like MSDN , and Experts-Exchange and was also the moderator for MSDN SQL Server forums, and holds the MCP in addition to MCSE, MCP, and MCITP for BI. He is the creator of the New Zealand Business Intelligence users group. The group is the author of the famous guidebook Power BI from Rookie to Rock Star, which is free and has more than 170 pages of material in addition to being component of Power BI Pro Architecture published by Apress.

 <br>

 It is an International Speaker at Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL User Groups. And He is a Microsoft Certified Trainer.

 <br>

 Reza's love is helping users find the best information solution. He is Data enthusiast.This post was uploaded in Power BI, Power BI from Rookie to Rockstar, Power Query and is listed under Power BI, Power BI from Rookie to Rock Star, Power Query. You can follow any comments to this entry through the RSS feed.

</p>

<h2>

 Post navigation

</h2>

<p>

 Share various visual pages by various security groups inside Power BIAge Calculation in Years which is able as a way to calculate Leap Year in Power Business Intelligence by using Power Query

</p>