PowerBI in 3 minutes :- Power Query - Indexing & conditional columns

The Index column command adds a new column to the table with explicit position values, and is usually created to support other transformation patterns.
By default, the starting index will start from the value 0 and have an increment of 1 per row.
You can also configure the behavior of this step by selecting the Custom option and configuring two parameters:
• Starting index: Specifies the initial index value.
• Increment: Specifies how much to increment each index value.
With Power Query, you can create new columns whose values will be based on one or more conditions applied to other columns in your table.

The Conditional column command is located on the Add column tab, in the General group.
For further information on Conditional column , please find the link below.

Enjoy this video and leave your valuable feedback. To know more about us, please visit our website.