cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Helper IV
Helper IV

Try a conditional column:

condcolumn.JPG

View solution in original post

4 REPLIES 4
Highlighted
Helper IV
Helper IV

Try a conditional column:

condcolumn.JPG

View solution in original post

Highlighted

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

Highlighted

Got it! Thanks!!!

Highlighted

Your Welcome! Glad to Help!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors