Forum Discussion
Gantt Chart - Duration
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"?
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:
Regards,
Xiaoxin Sheng
1 Reply
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:
Regards,
Xiaoxin Sheng