Gantt Chart - Duration

[jberuh]

I connected data from a SharePoint List to PowerBi. I have all the data that I need except for the "Duration." - I do however have an "End Date." 

Is there a way around it or some way to make PowerBi calculate the "Duration" from the "Start" and End Date"?

[v-shex-msft · Accepted solution]

Hi @jberuh,

If your table contains start date, you can try to use datediff function to create a duration column.

Sample:

Duartion= DateDiff(Table[StartDate],Table[EndDate],HOUR)

If you table not contains the start date, you should find it first then calculate with it.

Reference link:

DATEDIFF Function (DAX)

Regards,

Xiaoxin Sheng