Forum Discussion

SuzanneSte's avatar
SuzanneSte
Frequent Visitor
3 years ago

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 

 

     
Sales Person Hired MonthSales Month RevenueNo Months employed 
JohnNov-22Jul-23$50,1588
MaryFeb-23Jul-23$28,8004
PeterMay-23Jul-23$02
     
     
Need Help

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    3 years ago

    Hi 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

    • SuzanneSte's avatar
      SuzanneSte
      Frequent Visitor
      3 years ago

      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