cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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 trying to get a solution for my problem. Since I just started using Power BI, please give a solution in baby steps. Smiley Wink

 

I have highlighted the 2 columns which I need:

start en endprogress.png

 

 

 

Thanks very much,

 

Shahbaaz

4 REPLIES 4
Highlighted
Super User IX
Super User IX

Re: time calculation

See if Net Work Days helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper I
Helper I

Re: time calculation

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

 

syntax error calculation.png

Highlighted
Helper I
Helper I

Re: time calculation

Do you by any chance have a file with the solution where I check the DAX formula etc.? 

Highlighted
Super User IX
Super User IX

Re: time calculation

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)


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors