Working out Working Days SLA.

surkdidat

Well-known Member
Joined
Oct 1, 2011
Messages
594
Office Version
  1. 365
I am a complete newbie to Power BI - my only exposure being a one day crash course on creating dashboards, and I would know how to do this in Excel!

I cannot add anything to the original data source unfortunately, which in my head would make this far easier!

In my imported data I have column called "completedDataTime" and a further column called "requestedDateTime"

My filter column will be one called "Banner"

What my endgoal will be is to be is have a graph showing the average completion time for each banner and an overall one for all departments) (I will start with a graph for each department and a 5th one for all 4 departments combined) (As I know I can add a slicer to make it more interactive, but we do not need that at the moment)

Anyway, to simplify, I understand I need DAX Code to do this?

This needs to be working days only (ideally to exclude bank holidays - would I need to upload a separate spreadsheet with the dates I do not want to include in completion stats)?

Please let me know if you need anymore information
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top