I do have ready the working days for a given times BUT I am not able to calculate the working hours out if this.
buinessdays = CALCULATE(SUM('Date Dim'[BusinessDays]),DATESBETWEEN('Date Dim'[Date],'open'[Created On],'open'[Today]))
Any idea on this issue ?
I found something in other forum but is not working for me
Column = DATEDIFF(
WEEKDAY(Table1[Received_Time];2)>=5 && Table1[Received_Time]>timevalue("6:00:00 PM")
Please share some dummy data and clarify the corresponding desired results.
Please look at the sample raw data at :
Jose Miguel Rojas Prendas
I'm not able to view your dashboard. Please share sample data in Excel file and clarify desired results.