Forum Discussion
Formula for New Column
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 nullThen 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 , 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
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 nullThen 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.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 nullThen 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.