Log In
Register
Home
February 12, 2018
Offline
My goal is to covert hired dates to months with the company. I used the PQ to transform the date to age, then transformed the age to years using the Duration button, however, there is no months option in the dropdown, only total years, days, hours etc. Is there a way to transform to total months using the options in the transform ribbon or does this require a custom function using M code?
Thanks!
July 16, 2010
Offline
Hi Tykru,
There's no built in way to calculate it but this post offers a solution. However, it is simpler to do this calculation in Power Pivot using the DATEDIF function.
Mynda
November 8, 2013
Offline
Hi,
If you have the age in years, adding a column that multiplies the age by 12 should be enough, normally the age in years should have decimals, so 3.25 years*12 = 39 months for example.
February 12, 2018
Offline
Awesome, I will take a look at both and see what works for me. I considered using DAX in Power Pivot but am only working from one table so I didn't add to PP data model because how simplistic my solution is. Can you use PP to create measures with only one table?
Thanks!
July 16, 2010
Offline
Yes, DAX measures can be written for one table.
February 12, 2018
Offline
I've tried both Catalin's and your suggestion and they work great. However, when I round both 1 decimal place, the DAX version will round way up (i.e. the M code result will be 11.2 and the DAX will round up to 12.0). Any idea why?
Thanks,
Tyler
1 Guest(s)
