Forum Discussion
Calculate working days between 2 dates
Found the solution, after looking at all the threads. simply mistake = don't use New Measure, use New Column
Datesbetween is an inbuilt time intelligence function. These inbuilt functions are normally "syntax sugar" - in other words there is a more complex formula under the hood, but you are protected from it. All inbuilt time intelligence functions need to know where the date column is in your calendar table to be able to do the job. That is what this parameter is for - to tell the function where the date column is. You will see it in all inbuilt time intelligence functions
thanks...i got this error.
A single value for column 'Created Date Time' in table 'KPI' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Apologoies. Allowed me to elaborate. I have a column (consist of 30k+) of transaction created date, resolved date. I want to calculate the working days between these 2 dates. May I know what is the best way to calculate working days? (I don't need to involve Public Holidays).
My current formula as such
CALCULATE(SUM(Calendar_Updated[Work/NonWowrk Day]),DATESBETWEEN(Calendar_Updated[Date],('KPI'[Created Date Time],'KPI'[stat_DateTime Resolved]))
Found the solution, after looking at all the threads. simply mistake = don't use New Measure, use New Column