课程: Advanced Power Query

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Challenge: Count unique visits

Challenge: Count unique visits

课程: Advanced Power Query

开始一个月试用 购买团队方案

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.

内容