NETWORKDAYS Returning Incorrect Values

[drewison]

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 · Accepted solution]

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. 

[drewison]

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