Forum Discussion
Copy the Power BI Column Based on Conditions
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
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
2 Replies
- Jihwan_Kim
Super User
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())
