How To Add A Conditional Index In Power Query

In this video, Melissa is going to give a walkthrough on her approach for Bhavya Gupta’s Power Query Challenge involving Conditional Indexing. The task is to add an index number from 1 for each ID in the table and begins in the row after the values in the date columns hit more than or equal 90.

Link to the Power Query Challenge: https://bit.ly/3T9XBSJ

**** Video Details ****
00:00 Introduction
00:57 Group By
02:43 Table.RowCount
02:56 List.PositionOf
04:54 Generic list
06:00 List.Repeat
06:40 Restricting elements
07:50 Contstruct table
09:20 Expand nested tables

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://www.enterprisedna.co/power-bi-...
FREE - 60 Page DAX Reference Guide Download - https://www.enterprisedna.co/dax-form...
Enterprise DNA Membership - https://www.enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://www.enterprisedna.co/enterpri...

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial