Adding a Conditional Index Column in Power BI

If you're looking to add a conditional index column within Power BI, Enterprise DNA is here to guide you through the process. Using the Power Query Editor, this tutorial shows you how to add an index number beginning at 1 for each ID in a table, with the values in the date columns triggering the index to reset at 1.

The tutorial takes you through the steps of using a Group By in the ID column in the Power Query Editor. By following the best practices outlined in this tutorial, you'll be able to add a conditional index column with ease and precision.

If you prefer a visual guide, the post includes a video tutorial for you to follow along with. So whether you're a seasoned Power BI user or just starting, this tutorial will equip you with the knowledge to add a conditional index column like a pro.

Continue reading Adding a Conditional Index Column in Power BI at Enterprise DNA.