How to copy the values of a column based on condition

[infantpowerbi]

Dear All,

I am from Tableau background and not so good in DAX expressions,
Below is my sample table format , Where I need to copy the values of Column Value to Column
A value where the Application Column is "A" .
I tried it in Edit Query and creating custom column but unable to get the result based on condition

Can any one please help me how can I make it

[Anonymous · Accepted solution]

@Anonymous 

You can achieve with the help of 'Conditional Column' in the 'Add Column' ribbon in the Query Editor

Select Column in the Output showned in the below image

Nandri

[AlB]

Hi @infantpowerbi 

You can use this code in the custom column:

if [Application] = "A" then [Value] else null

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers