Search found 2 matches

by Miguel-san
Sun Oct 13, 2019 8:05 am
Forum: Excel
Topic: Process imported csv data - Classification
Replies: 0
Views: 1757

Process imported csv data - Classification

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...
by Miguel-san
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: 538

Workplace time keeping - DAX to get the earliest check-in time within a day for a specific person

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

Go to advanced search