Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
Solved! Go to Solution.
Try a conditional column:
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!
User | Count |
---|---|
59 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
80 | |
62 | |
45 | |
40 | |
39 |