Forum Discussion
Help needed
Hello, I am trying to create a calculated column that will calculate and hold 'no months employed', taking the month a sales person was hired from the sales month - can you advise me please ...
Nathaniel_C
Community Champion
Community ChampionHi SuzanneSte ,
Please try this.
No Months Employed New = DATEDIFF([Hired Month],[Sales Month ],MONTH)
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Thats great - thank you, but I am running into difficulty because they are in separate tables. I have been trying to use the RELATEDTABLE function but struggling