Formula for New Column

[MHedgeiusMagnus]

Hi,

I am trying to create a new column (D) where the "starting status" would be be populated in a new column.  It would be based on the info in column B.  Is there a solution to this?  Thank you.

[MHedgeiusMagnus]

Hi,

Attached is what it show when index column is added.  

[amitchandak]

@MHedgeiusMagnus , Add index column in power Query

New column =
var _ind = maxx(filter(Table, [Index] <earlier([Index]) && Isblank([C])),[Index])
return
maxx(filter(Table, [Index] =_ind && Isblank([C])),[B])

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

[MHedgeiusMagnus]

In your Query Editor, create a Conditional Column that is called New Column (or Starting Status).
The formula would be
if [Rank] = null then [Pitcher] else null

Then highlight the New Column/Starting Status and go to the Transform tab > Fill > Fill Down
You can then filter to exclude the nulls in the Rank column, but only if you need to.
Close and Load.

[MHedgeiusMagnus · Accepted solution]

In your Query Editor, create a Conditional Column that is called New Column (or Starting Status).
The formula would be
if [Rank] = null then [Pitcher] else null

Then highlight the New Column/Starting Status and go to the Transform tab > Fill > Fill Down
You can then filter to exclude the nulls in the Rank column, but only if you need to.
Close and Load.