Forum Discussion

jberuh's avatar
jberuh
New Member
9 years ago
Solved

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 Pow...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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