-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 22-
(Excel formulas also welcome for Power Query Challenges)
Since yesterday’s Power Query Challenge stretched people a lot, here is a lighter challenge.
Table in column A is list of employees.
Table in columns C:D is the attendance record of those employees for a given day. They can swipe multiple times in a day.
You need to generate the result table which is the count of swipes for an employee for a day.
Download Practice File - https://lnkd.in/dZUVJNxS
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #data, #analytics, #businessintelligence, #finance
Excel BI’s LinkedIn Post