Forum Discussion
Anonymous
7 years agoNot applicable
time calculation
Hi, I am trying to calculate how long it takes for incoming tickets to be resolved excluding weekends and holidays. I posted earlier a message about this but the data columns were old so I am try...
Greg_Deckler
7 years agoCommunity Champion
See if Net Work Days helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362
Anonymous
7 years agoNot applicable
Hi Greg, thanks for you message. Unfortunately I keep getting the following syntax error and I have now clue why. I have just changed the name of the measure and thats it. Please help me
- Greg_Deckler7 years agoCommunity Champion
Seems like your table name is incorrect and it should be the one that is highlighted in yellow in your image. Also, you will need to update ","'s to ";" in your third line (including the name of your measure)