Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello DAX experts 🙂
I'am trying to figure out the formula that calculate an average time spent (in months) in company by previous and active employees (splitted by time periods - months/years). So I got 'start date' column and 'end date' column (for active emloyees remains empty). I did try DATEIFF function but every time it gaves me wrong numbers. Can somebody help me?
Employee | Start date | End date |
A | 2/7/2011 | |
B | 2/14/2011 | 1/4/2016 |
C | 6/1/2011 | |
D | 6/1/2011 | 7/7/2014 |
Solved! Go to Solution.
Typically, I like to add an "Age" column in the query, rather than creating a calculated column with DAX, in the data model. For example, to do an "Age in Days" column...
Or, if you do want to use a calculated column with a DAX formula, this works for me:
Age in Months = DATEDIFF([Start Date], [End Date], MONTH)
Hi @kb,
Have you resolved your issue? You'd better list your expected result according to the sample data. It's difficult to reproduce how to calculate the average time time according to your description.
Best Regards,
Angelia
Hi there,
Here is the image how to do it:
Typically, I like to add an "Age" column in the query, rather than creating a calculated column with DAX, in the data model. For example, to do an "Age in Days" column...
Or, if you do want to use a calculated column with a DAX formula, this works for me:
Age in Months = DATEDIFF([Start Date], [End Date], MONTH)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |