Lorraine has attended:
Power BI Modelling, Visualisation and Publishing course
Help with clockings!
I have some basic clocking data and I need to pick the first and last clockings for each person by day. Have no idea how to start!
RE: Help with clockings!
Hi Lottie,
Thank you for the forum question and thank you for the nice feedback. I am happy that you found the course useful.
Can I please ask you to send me a sample of the data. I will need to see how the data are organised and structured in the source.
You can send the sample to:
info@stl-training.co.uk
Thanks
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Help with clockings!
Hello Jens
Just emailed the file
Thank you for your help
Lottie
RE: Help with clockings!
Hi Lottie,
Please find attached Power BI file. You can see the 3 measures I have done in the aacalc table and you can see the result in the table page 1.
I got a sample of your data. Many of the employees only have one record, that is why the table shows that many of the employees have 0 working hours in the last column in the table.
I hope it is what you want,
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
RE: Help with clockings!
Hello
Have you emailed me the file? I can't see it?
Thank you
Lottie
RE: Help with clockings!
Hi Lottie,
You should be able to see the attachment just under my last reply.
I have also told my office to email it to you.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
