Formula for New Column on Power BI

[Matthew Hedge]

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.

 

[johnny51981]

Hi @Matthew Hedge
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.

 

[Matthew Hedge]

Hi @Matthew Hedge
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.

Hi,

Thanks for the response. It did not achieve the desired result.

 

[johnny51981]

I think you haven't done this part yet:
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.

 

[Matthew Hedge]

Hi @Matthew Hedge
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.

Hi.
Missed this part.

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.

It works great!. Thank you.

 

[johnny51981]

Yay!!