Create Lead time from 2 date columns out of the database

[Sven]

Hello Power BI community,

I am new to Power BI and i am trying to extract 2 dates in the same database.

So I tried in the query editor to add a column: [date1] - [date2] = Lead Time in days, but an error appeared, because Power BI cannot use the operator '-' for a date column.

So I tried to use the measure datediff(date1;date2;1), but Power BI cannot find my tables.

Can anyone help me out, how to fix this?

Thanks in advance!!

[Eric_Zhang · Accepted solution]

---

@Sven wrote:

Hello Power BI community,

I am new to Power BI and i am trying to extract 2 dates in the same database.

So I tried in the query editor to add a column: [date1] - [date2] = Lead Time in days, but an error appeared, because Power BI cannot use the operator '-' for a date column.

So I tried to use the measure datediff(date1;date2;1), but Power BI cannot find my tables.

Can anyone help me out, how to fix this?

Thanks in advance!!

---

@Sven

When using DAX, you could try

days diff = DATEDIFF(yourTable[date1],yourTable[date2],DAY)

When adding a custom column in Power Query,

Duration.Days([date2]-[date1])