Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
GeorgesKV
Helper I
Helper I

Copy data from column if another column contains yes?

Hi!

So I have Column A and Column B, column A contains numbers and Column B contains "yes" or "no" I need a Column C that will copy the numbers from Column A if that row contains "yes" in Column B.

I know how to make a calculate column with this but I don't know the dax comand to "copy", "replicate" or "mirror".

Anyone know?

1 ACCEPTED SOLUTION
Christann
Advocate IV
Advocate IV

Try a conditional column:

condcolumn.JPG

View solution in original post

4 REPLIES 4
Christann
Advocate IV
Advocate IV

Try a conditional column:

condcolumn.JPG

But with this don't I need to write something on "output"? I need it to copy the same data.

Got it! Thanks!!!

Your Welcome! Glad to Help!

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.