Document editing comes as an element of many occupations and careers, which is why instruments for it must be reachable and unambiguous in terms of their use. An advanced online editor can spare you a lot of headaches and save a substantial amount of time if you need to Index conditional field invoice.
DocHub is a great example of an instrument you can master right away with all the valuable features accessible. Start modifying instantly after creating an account. The user-friendly interface of the editor will help you to find and utilize any function right away. Feel the difference with the DocHub editor as soon as you open it to Index conditional field invoice.
Being an important part of workflows, document editing must stay easy. Using DocHub, you can quickly find your way around the editor and make the required alterations to your document without a minute wasted.
[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