Age Calculation

Age Calculation in Power BI using Power Query

Power Query has a simple method that's a basic method for calculating the age. However, because DAX is the largest and most well-known language usedin several calculationsin Power BI, a lot of people don't have any idea about the feature available in Power Query. In this blog , I'll discuss how easy it can be to calculateAge for PowerBI by using PowerBI. This methodis very helpful for situations when it is necessary to calculate the calculation of age.can be done in a previous row-by-row basis.

Calculate Age from a date

This is an example of the DimCustomer table , and it is from the AdventureWorksDW table which functions as the column for birth dates. I've eliminated columns that aren't needed in order to make it more clear;

For you to calculate your age for every customer, you will need:

  • In Power BI Desktop, Click on Transform Data
  • In the PowerQuery Editor window, make sure to choose the column titled Birthdate first.
  • You can go to the add Column Tab located under the "From Date & Time" section, and under Date, select Age

That's about it. This will calculate any differences within the Birthdate column, as well as the current date and hour.

However, the age you can see when looking at the Age column, doesn't look like an actual age. It's because it's not a duration.

Duration

Duration is a particular type of data that is utilized for Power Query which represents the distinction between the two DateTime values. Duration is a mixture of four values:

days.hours.minutes.seconds

and that's what you'll see in the information above. However, from a users' point of view, they shouldn't be required to read information in the same way as those mentioned above. There are many ways to locate every component of time. Through the Duration menu you'll see that you can extract the quantity of seconds, minutes, hours days , and even years from it.

To assist in calculating the age in years for instance it is easy for you to reach the Total Year:

Be aware that the duration of the event is measured in days . It was then divided by 365 for the year to get the total.

Rounding

Truthfully, no one has stated how old their baby is. 53.813698630136983! They say 53, which is an rounded down. It's very easy to select Rounding option , and then to round down to the Transform tab for it.

This will give you the years of experience:

You can then tidy other columns as you'd like (or there's a chance that you've used transformations using the Transform tab to stop creating new columns) This column is then referred to as column"Age".

Things to Know

  • Refresh The age calculated this way will be modified at the time of refreshing your data. Every every time it is refreshed, it'll match the birthdate to the date of the day and the time the refresh was made. This method is an earlier calculation of age. If, however, you'd like your age calculation to be conducted dynamically, using DAX This is the method I've shown you how you can make use of.
  • The motive for using Power Query: Benefits of performing an age calculation by using Power Query is that the calculation is carried out after you refresh the report. It's done with an algorithm that makes the calculation more easy to do, and there won't be any additional overhead when calculating it using DAX for a measurement of of runtime.
  • Different scenarios. This isn't meant to be used for calculation of the age of a person based on their birth date. This could be used in conjunction with inventory of products and distinct dates and dates from each other.

Video

REZA RAD

TRAINER, CONSULTANT, MENTORReza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He earned a BSc and MSc Computer engineering. He have more that 20 years of experience in data analysis , the BI and databases fields, as well as programming and development generally using Microsoft technologies. He was a Microsoft Data Platform MVP for nine consecutive years (from 2011 until the present) for his passion and dedication to Microsoft BI. Reza is a regular blog writerand director and co-founder of RADACAD. Reza is also co-founder as well as co-organizer of Difinity the conference that is held in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He has written a number of books about MS SQL BI and also is working on other books. He also was a regular member of online forums on technical issues , such as MSDN and Experts-Exchange, and was moderator on the MSDN SQL Server forums, and holds an MCP and the MCSE, as well as an MCITP in Business Intelligence. He was the creator of the New Zealand Business Intelligence users group. He's also the author of very popular books Power BI from Rookie to Rock Star, which is available for download for free and includes more that 170 pages of content. It also contains The Power BI Pro Architecture published by Apress.
It is an International speaker on Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday, and SQL Users Groups. And He is a Microsoft Certified Trainer.
Reza's ambition is to help you find the ideal solutions for data. He's a Data enthusiast.This post was posted in Power BI, Power BI from Rookie to Rockstar, Power Query and included in Power BI, Power BI from Rookie to Rock Star, Power Query. The following is a good tool to save to your bookmarks.

Post navigation

Create Different Visual Pages by using different security groups in Power BIAge's Calculation of Years that is used for Leap Year in Power BI by making use of Power Query

Comments

Post a Comment

Popular posts from this blog

Alliance Meaning In Tamil - தமிழ் பொருள் விளக்கம்

   " Alliance " தமிழ் மொழிபெயர்ப்பு, பொருள், வரையறை, விளக்கம் மற்றும் தொடர்புடைய சொற்கள் மற்றும் புகைப்பட எடுத்துக்காட்டுகள் - நீங்கள் இங்கே படிக்கலாம். Alliance   ♪ : /əˈlīəns/ பெயர்ச்சொல் : noun உறவு திருமணம் நண்பர் கூட்டணி இராச்சியம் கூட்டணி கூட்டணி விவாக சம்பந்தம் சிநேகம் உடன்பாடு நட்ப தொடர்ப நட்புத்தொடர்பு இணக்கநிலை நேரசாடு திருமணஉறவு உறவு ஒப்பந்தம் இந்தியா மற்றும் அமெரிக்காவுக்கு இடையே ஒரு தற்காப்பு கூட்டணி உருவாக்கப்பட்டது சங்கம் ஒன்றியம் கூட்டிணைவு உடன்படிக்கை கூட்டுறவு உடந்தை கிழமை சினேகம் சேர்க்கை துணை நாடுகளுக்கு இடையிலான கூட்டணி ஒப்பந்தம் உறவு கூட்டணி திருமணத்தின் மூலம் உறவு இணைந்து விளக்கம் : Explanation பரஸ்பர நலனுக்காக உருவாக்கப்பட்ட ஒரு தொழிற்சங்கம் அல்லது சங்கம், குறிப்பாக நாடுகள் அல்லது அமைப்புகளுக்கு இடையே. ஆர்வங்கள், இயல்பு அல்லது குணங்களில் உள்ள உறவை அடிப்படையாகக் கொண்ட உறவு. இணைந்த அல்லது இணைந்த நிலை. கூட்டணி அல்லது கூட்டமைப்பு நிலை உறவு அல்லது திருமணம் அல்லது பொதுவான ஆர்வத்தின் அடிப்படையில் ஒரு ...
Read more

Random Number Generator

Random Number Generator Utilize this generator to generate an completely random secure, cryptographically secure number. It generates random numbers that can be utilized when accuracy of the results is critical such as when shuffling decks of cards for an online poker game, or when drawing numbers for drawings, numbers for lottery or sweepstakes. What is the best way to choose your random number from two numbers? You can utilize this random number generator in order to locate an original random number among any two numbers. For example, to get a random number that is between one and 10. 10 input 1 into the initial input and 10 into the next. After that, press "Get Random Number". The randomizer will pick a number between 1 and 10 random. In order to generate a random number between 1 and 100 it is possible to do exactly the same thing, however, using 100 being the second area of the selection. When you want to simulate the roll of a die, the range should ...
Read more

Shani Dev Chalisa Hindi

  श्री शनि देव चालीसा | Shani Dev Chalisa Hindi ( shani chalisa pdf ) ॥दोहा॥ जय गणेश गिरिजा सुवन, मंगल करण कृपाल। दीनन के दुःख दूर करि, कीजै नाथ निहाल॥ जय जय श्री शनिदेव प्रभु, सुनहु विनय महाराज। करहु कृपा हे रवि तनय, राखहु जन की लाज॥ हे माता पार्वती के पुत्र भगवान श्री गणेश, आपकी जय हो। आप कल्याणकारी है, सब पर कृपा करने वाले हैं, दीन लोगों के दुख दुर कर उन्हें खुशहाल करें भगवन। हे भगवान श्री शनिदेव जी आपकी जय हो, हे प्रभु, हमारी प्रार्थना सुनें, हे रविपुत्र हम पर कृपा करें व भक्तजनों की लाज रखें। ॥चौपाई॥ ( shani chalisa pdf ) जयति जयति शनिदेव दयाला। करत सदा भक्तन प्रतिपाला॥ चारि भुजा, तनु श्याम विराजै। माथे रतन मुकुट छवि छाजै॥ परम विशाल मनोहर भाला। टेढ़ी दृष्टि भृकुटि विकराला॥ कुण्डल श्रवण चमाचम चमके। हिये माल मुक्तन मणि दमके॥ कर में गदा त्रिशूल कुठारा। पल बिच करैं अरिहिं संहारा॥ हे दयालु शनिदेव महाराज आपकी जय हो, आप सदा भक्तों के रक्षक हैं उनके पालनहार हैं। आप श्याम वर्णीय हैं व आपकी चार भुजाएं हैं। आपके मस्तक पर रतन जड़ित मुकुट आपकी शोभा को बढा रह...
Read more