Copy the Power BI Column Based on Conditions

[Anonymous]

Hello All,

I need to create a Calulcated Column and Capture the Value from other Column based on conditions.

ID                  Attribute                         Status

1001           Application                      Completed
1002           Non-Application              InComplete
1003           Application                      Completed

As shown above need to copy only Status column Value in newly calucalted column if Attribute column is "Application"

Can any one please help me in getting this

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below pictures.

One is creating a new column inside the same table.

The other is creating a new table based on the inquiry that applies to the existing table.

 

Status Copy CC =

IF( 'Table'[Attribute] = "Application", 'Table'[Status])

Status column Tables =

SUMMARIZECOLUMNS (

'Table'[ID],

'Table'[Attribute],

'Table'[Status],

FILTER ( 'Table', 'Table'[Attribute] = "Application" )

)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[amitchandak]

@Anonymous , Try a new column 

if([Attribute] = "Application",[Status], blank())