Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
4 years ago

Dynamic Column for Expierence

Hai Guys, Thank you for your support for the old post
I have another requirement
I have Two dates Column 1. Joining date 2.Current date (Dynamic Column)
Based on these two I want to create a calculated column That is the Total Experience column for each employee. 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    4 years ago

    AlanP514 , Try this DAX code:

    Total Experience (in Year) = DATEDIFF(TableName[JoiningDate]),TableName[CurrentDate]),YEAR)

     

     

  • Thejeswar's avatar
    Thejeswar
    Super User
    4 years ago

    HI AlanP514 ,

    You can create a calculated column as below

     

    Calculated_column = INT(TODAY() - 'Table'[Joining_Date])

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi AlanP514 

     

    You can try the following methods.

    Column:

    Current date = TODAY()
    Total Experience = DATEDIFF([Joining_Date],[Current date],DAY)

    Is this the result you want?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.