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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to calculate date difference within same column

Hi everyone,

 

Good afternoon! I would like to ask how to get the date difference of the start and end date in one column (the same column).

I have a different status for each track ID, but I need to get the date difference per status. Is it possible to calculate within same column? (Note: S - start date, E - end date)

katerinepr_0-1649052885209.png

 

1 ACCEPTED SOLUTION
AntonioM
Solution Sage
Solution Sage

Hi, If you want to add a new column, I would try

 

StartToEnd =

VAR startdate = CALCULATE(MIN(Table[Signoff Date]),FILTER(Table, Table[Change Number] = EARLIER(Table[Change Number]) && Table[Status] = EARLIER(Table[Status])))

VAR enddate = CALCULATE(MAX(Table[Signoff Date]),FILTER(Table, Table[Change Number] = EARLIER(Table[Change Number]) && Table[Status] = EARLIER(Table[Status])))

RETURN DATEDIFF(startdate, enddate, DAY)

 

That should give you a duration for each combination of Change Number and Status

View solution in original post

2 REPLIES 2
AntonioM
Solution Sage
Solution Sage

Hi, If you want to add a new column, I would try

 

StartToEnd =

VAR startdate = CALCULATE(MIN(Table[Signoff Date]),FILTER(Table, Table[Change Number] = EARLIER(Table[Change Number]) && Table[Status] = EARLIER(Table[Status])))

VAR enddate = CALCULATE(MAX(Table[Signoff Date]),FILTER(Table, Table[Change Number] = EARLIER(Table[Change Number]) && Table[Status] = EARLIER(Table[Status])))

RETURN DATEDIFF(startdate, enddate, DAY)

 

That should give you a duration for each combination of Change Number and Status

Anonymous
Not applicable

Hi! Thanks a lot for this! It worked perfectly. To add, could you also help me how can I remove weekends in the calculation? Appreciate your help.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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