duration of a person's designation

[HassanAli123]

Hi,

    I have two columns effective from and current position. i want to compute a colum of duration which will let us know the duration of a person designation. for example the duration of "assistant manager" will be 2 year and duration of "head" will be 8 years and 2 months. how can we find it through DAX.

Thnaks in advance

   

[v-henryk-mstf]

Hi @HassanAli123 ,

Whether the advice given by @truptis @mh2587  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[HassanAli123]

actually i didn't try these solutions. I posted this question again and @amitchandak solved my problem. 

[v-henryk-mstf]

Hi @HassanAli123 ,

Can you provide a link to the solution here? Looking forward to your reply.

Best Regards,
Henry

[HassanAli123 · Accepted solution]

Solved: calculate employee position Duration - Microsoft Power BI Community

[mh2587]

Duration =
VAR CurrentDate = CALCULATE ( MAX(Table[effective from] )

)

var LastDate = CALCULATE(

MAX(Table[effective from]),

Table[effective from] < CurrentDate )

VAR DD = DATEDIFF ( LastDate,CurrentDate, Year )

RETURN DD

[truptis]

Hi @HassanAli123 ,

You can use DATEDIFF function here. 

Eg - Result_for_years = DATEDIFF(effective_form, Today(), Year) 
(for first row, this will return no. of years between 01/01/2012 to today's date)
Result_for_months = DATEDIFF(effective_form, Today(), Month)
(for first row, this will return no. of months between 01/01/2012 to today's date)
Result_for_days = DATEDIFF(effective_form, Today(), Day)
(for first row, this will return no. of days between 01/01/2012 to today's date)

@HassanAli123 -> Please mark this as a solution if it helps you. Thank you.

Regards,

TruptiS

[HassanAli123]

actually you did not get my point. the person is same in both designation. i want to calculate duration separately for assistant manager it should calculate till 2014 mean 2 years and 8 year 2 months for head roll

[truptis]

yes @HassanAli123 , it will give you the desired output.