Forum Discussion
Date/Time subtraction from columns in SharePoint list
Hello, I have a SP list I brought into BI and I need to subtract the date & time from specific keywords in another column, see the snippet below: I need to subtract the date & time w...
v-frfei-msft
Community Support
Community SupportHi SolarWill ,
To create a measure as below.
Measure =
VAR odate =
CALCULATE (
MAX ( 'Table'[Created] ),
FILTER ( 'Table', 'Table'[Status] = "Open" )
)
VAR inprogress =
CALCULATE (
MAX ( 'Table'[Created] ),
FILTER ( 'Table', 'Table'[Status] = "In Progress" )
)
RETURN
DATEDIFF ( odate, inprogress, MINUTE )
Hello, I tried your measure and adjusted for my table name - there are no syntax errors but when I add the measure all of a sudden all of the data dissappears:
- v-frfei-msft
Hi SolarWill ,
Kindly share your PBIX to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.