When you want to apply a small tweak to the document, it should not take long to Index conditional field article. This kind of simple activity does not have to demand additional training or running through handbooks to learn it. Using the right document modifying resource, you will not take more time than is needed for such a quick edit. Use DocHub to streamline your modifying process regardless if you are an experienced user or if it’s your first time using an online editor service. This tool will require minutes or so to figure out how to Index conditional field article. The sole thing required to get more productive with editing is actually a DocHub profile.
A simple document editor like DocHub will help you optimize the time you need to spend on document modifying irrespective of your prior knowledge about this kind of tools. Create an account now and improve your productivity instantly with DocHub!
[Music] thank you hi everyone my name is Melissa and in this video I want to go over my approach to the conditional index challenge by bahati Gupta the task is to add an index number that restarts for each ID and begins in the row after the values in the date column hits 90 or greater than 90. if you havent participated yet and want to give this a go yourself I highly recommend it its loads of fun youll find the link in the description of this video alright lets go to the power query editor Im going to start with a group Buy on the ID column because that will return the table with unique ID values now there are three places where you can find Groupon so its in the transform section on the Home tab on the transform tab its in the table section right here but you can also right click the column header and find Group by there so it opens this dialog and you can do all kinds of aggregations here but I only want to segment my data therefore Ill choose the operation all rows and Il