Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Calculate working days between 2 dates

Hi All,   I was trying for long time and couldn’t break this through. I was trying to get the “networkdays” in excel equivalent at PowerBI. After rounds of searching online, I believe the below s...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Found the solution, after looking at all the threads. simply mistake = don't use New Measure, use New Column

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Found the solution, after looking at all the threads. simply mistake = don't use New Measure, use New Column