Forum Discussion

drewison's avatar
drewison
Frequent Visitor
3 years ago
Solved

NETWORKDAYS Returning Incorrect Values

I am having an issue where some of the work day calculations are doubling (example below). Any ideas on what might be causing this error? 

Number of Days = NETWORKDAYS(Query1[Start], Query1[Finish],1,(VALUES(Holidays[Holiday Date])))
 

  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi drewison 

    I believe this just a duplicate record. If you check your sorce data table, you should find two rows having the same values of all the columns ised in this table visual. To confirm this place a measure COUNTROWS ( Query1 ) and place it in the same table visyand check if you get 2 as well. 

2 Replies

  • drewison's avatar
    drewison
    Frequent Visitor
    3 years ago

    tamerj1 thank you for the help. I had forgotten about hidden rows that duplicated the input. 

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi drewison 

    I believe this just a duplicate record. If you check your sorce data table, you should find two rows having the same values of all the columns ised in this table visual. To confirm this place a measure COUNTROWS ( Query1 ) and place it in the same table visyand check if you get 2 as well.