• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Distribution of hours worked by employees en DAX

Aquila

New Member
Hello, I need help to be able to classify the hours worked by the employees of a company into a time range (from 0 to 6, from 6 to 12, from 12 to 18 and from 18 to 24) ( You have an employee table with the hours worked by date). I developed the example in excel, but I need to do the same in dax, powe pivot or power bi.

72490

For example, if an employee worked :
72491

attached the file in excel
 

Attachments

  • hours worked.xlsb
    11.5 KB · Views: 3
Back
Top