Forum Discussion
Formula for New Column
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.
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.
4 Replies
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.
Hi,
Attached is what it show when index column is added.
