Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi community..!!
I wanted to append the two columns in one column. Please refer the below image.
I wanted to create new column called as No_of_finals and in that I wanted to append Winner and Runners_up
Please anyone could you help me to do that..??
waiting for quick respose..
Solved! Go to Solution.
HI @ppatil
I am not sure if you could create that column in same table. Instead you can try to create seperate table with below code:-
table2 = UNION(VALUES(table[winner]),VALUES(table[runner-up]))
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
HI @ppatil
I am not sure if you could create that column in same table. Instead you can try to create seperate table with below code:-
table2 = UNION(VALUES(table[winner]),VALUES(table[runner-up]))
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
List.Combine(Table.ToColumns(#"Previous Step"))
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
I'm not familiar with List.Combine buy you try either of these options
= Table.AddColumn(#"Previous Step", "No_of_finals", each [Winner]&[Runners-Up])
or
= Table.AddColumn(#"Previous Step", "No_of_finals", each Text.Combine({[Winner], [Runners-Up]}, ""), type text)
where #"Previous Step" refers to the name of the last step in your current query
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |