课程: Advanced Power Query

免费学习该课程！

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

Solution: Count unique visits

Solution: Count unique visits

课程: Advanced Power Query

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

Solution: Count unique visits

“

(upbeat music) - Okay, let's just talk about the solution to the problem of counting unique visits. Obviously, I'm going to solve that using records. There are just one or two formulas that we haven't explicitly spoken about, in case you are not able to find them, that's totally all right. There was a lot of things that we had already done in the past videos, just one or two new formulas, you will learn them as well in this video. Let's just take a look at the solution. All right, let's just take a look at how do we solve this problem? So I have already gotten this data in Excel. I'm going to click on Data and then load this data into Power Query. Once the data has been loaded inside of Power Query, what I'm going to do now is obviously remove the changed type step that has been created, and I'm going to start to create a new column. So in the Add Column tab, make a custom column. And in the custom column, I'm going to call this as Unique Visit Count, and then I'm going to start to…

内容