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"?
Go to Solution.
If your table contains start date, you can try to use datediff function to create a duration column.
If you table not contains the start date, you should find it first then calculate with it.
DATEDIFF Function (DAX)
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!