From the course: Advanced Power Query

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Challenge: Count unique visits

Challenge: Count unique visits

From the course: Advanced Power Query

Start my 1-month free trial Buy for my team

Challenge: Count unique visits

“

(upbeat music) - All right, now that you've learned a few things about records, let me challenge you with this interesting problem. All right, I'm working in this Excel file, and on one side, we have the store, and on the other side, we have the visits. And we have to create one column right here that is going to give me the count of the unique visits. So, for instance, if you take a look at store A, 14th of January is duplicated, but I just have to make a count of that only once. And the second is going to be 10th January, 6th January, 2nd January, and 15th of January. So, the number of unique visits for the first row is just going to be five. So, you have to find out the unique visits for every single row and then place the value right here as a new column. That is your simple task. And, of course, you're going to do that using records. Let's get to work.

Contents