I have Excel sheet where open Date is available in A column, And Time is available in B column, and closing date & time available in C & D Column. How can i find total time duration between open date & closing date. Thank you for your advise. BR, John Paul. Reply Alexander Trifu...
COUNTA(SharePoint[Name] ) ) "Sharepoint[Created]" is a date field and I have a relationship between that and a universal Dates table Here is my Cumulative total: Cumulative total = CALCULATE( COUNTA(SharePoint[Name]), FILTER( ALLSELECTED('SharePoint'), SharePoint[Created] <= m...
COUNTA(SharePoint[Name] ) ) "Sharepoint[Created]" is a date field and I have a relationship between that and a universal Dates table Here is my Cumulative total: Cumulative total = CALCULATE( COUNTA(SharePoint[Name]), FILTER( ALLSELECTED('SharePoint'), SharePoint[Created] <= max (Share...
COUNTA(SharePoint[Name] ) ) "Sharepoint[Created]" is a date field and I have a relationship between that and a universal Dates table Here is my Cumulative total: Cumulative total = CALCULATE( COUNTA(SharePoint[Name]), FILTER( ALLSELECTED('SharePoint'), SharePoint[Created] <= ...