Date Difference between 2 dates from 2 rows

[Anilkumardoddi]

Hi All,

Program	Milestone	Dates	Delay days
KL-41	A0	06-Nov-25
KL-41	P1	17-Nov-25
DH-05	A0	22-Jan-25
DH-05	P1	29-Aug-25
Ak-220	A0	10-Aug-23
Ak-220	P1	03-Nov-25

In Power BI, I want to calculate the number of days between the P1 and A0 dates for each program.

For example:

• For KL-41, the delay should be 11 days, which is the difference between (17-Nov-2025) – (06-Nov-2025).

Could you please guide me on how to achieve this in DAX?

Thanks in advance!

@Bibiano_Geraldo @rajendraongole1 @Ritaf1983 @danextian @lbendlin @Ritaf1983 @bhanu_gautam
@MohamedFowzan1 

[Shahid12523 · Accepted solution]

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.

[bhanu_gautam · Accepted solution]

@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)

[Anilkumardoddi]

Thank you 🙂

[v-menakakota]

Hi @Anilkumardoddi  ,
Thanks for reaching out to the Microsoft fabric community forum.

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.

[v-menakakota]

Hi @Anilkumardoddi ,

Can you please confirm whether the issue is sorted or not.

Thank you.

[Anilkumardoddi]

Hi Menakakota, the above information was very helpful. I was able to resolve my issue. Thanks a lot, everyone!

[v-menakakota]

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. 

[Shahid12523 · Accepted solution]

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.

[Anilkumardoddi]

Thanks, this helps 🙂