Search found 2 matches
Search found 2 matches • Page 1 of 1
- Sun Oct 13, 2019 8:05 am
- Forum: Excel
- Topic: Process imported csv data - Classification
- Replies: 0
- Views: 1139
Hello all, I need to import external csv data files into an excel table. Then, I need to classify manually the data so I create a new column for it. The problem is that every time I refresh the query to get new data, the rows are moved according to the new csv file data however the rows of the colum...
- Thu Mar 21, 2019 8:47 am
- Forum: PowerPivot/DAX
- Topic: Workplace time keeping - DAX to get the earliest check-in time within a day for a specific person
- Replies: 1
- Views: 393
Hello, I want to analyse what time people get to work in relation to the official start time. Our key fob system gives me a report with the time when people get-in and get-out (in different columns) of the building everyday. However, they can get in and out several times within a day. This means tha...