Forum Discussion
Date Difference between 2 dates from 2 rows
- 11 months ago
Option 1: Calculated Column
If you want the delay at the program level, create a calculated column in your table:
Delay Days =
VAR ProgramID = Table1[Program]
VAR A0Date =
CALCULATE (
MIN ( Table1[Dates] ),
Table1[Program] = ProgramID,
Table1[Milestone] = "A0"
)
VAR P1Date =
CALCULATE (
MIN ( Table1[Dates] ),
Table1[Program] = ProgramID,
Table1[Milestone] = "P1"
)
RETURN
DATEDIFF ( A0Date, P1Date, DAY )
This will give you the days difference for each program.Option 2: Measure
If you only need it as a measure (e.g., in a table visual with Program):
Delay Days =
VAR A0Date =
CALCULATE (
MIN ( Table1[Dates] ),
Table1[Milestone] = "A0"
)
VAR P1Date =
CALCULATE (
MIN ( Table1[Dates] ),
Table1[Milestone] = "P1"
)
RETURN
DATEDIFF ( A0Date, P1Date, DAY )
When you put this measure in a table visual with Program, it will show the delay. - 11 months ago
Anilkumardoddi , Create a calculated column
DelayDays =
VAR A0Date = CALCULATE(
MAX('YourTable'[Dates]),
'YourTable'[Milestone] = "A0"
)
VAR P1Date = CALCULATE(
MAX('YourTable'[Dates]),
'YourTable'[Milestone] = "P1"
)
RETURN
DATEDIFF(A0Date, P1Date, DAY)
Hi Anilkumardoddi ,
Can you please confirm whether the issue is sorted or not.
Thank you.
Hi Menakakota, the above information was very helpful. I was able to resolve my issue. Thanks a lot, everyone!
- v-menakakota11 months agoCommunity Support
Hi Anilkumardoddi ,
Thank you for the update. Can you please mark the solution as "Accept as Solution", This would be helpful for other members who may encounter similar issues.Thank you for your understanding and assistance.