How To Add A Conditional Index In Power Query

Posted on by Annie D

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 – <a href=”http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi” target=”_blank” rel=”nofollow”>http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

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

Enterprise DNAMon, October 17, 2022 5:37pm