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
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