Custom Column

[heygau]

"I want to develop an index column in Power Query. If the EMI column has a value, it should generate an index column value (starting from 1). If the EMI column is empty, the index column should also be empty.

The table name is Awex, which consists of 20 columns. The EMI value occurs once or twice in a month, while the rest of the days the EMI column is empty."

 

Thanks For your Help 

[amitchandak]

@heygau , Try Rank in power query

Rank in Power Query? Power Query Table.AddRankColumn : https://youtu.be/bnB1rgAhZaw