Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## duration of a person's designation

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

1 ACCEPTED SOLUTION
Helper I
8 REPLIES 8
Community Support

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

Helper I

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

Community Support

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

Best Regards,
Henry

Helper I
Super User
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

Did I answer your question? If so, please mark my post as a solution!

Proud to be a Super User!

Community Champion

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

Helper I

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

Community Champion

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

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors