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.
Good morning
I want to pass data from one column to another column to be one, but I have not found the way or function to do it,
What I need is for the WTG and WTG_1 columns to be one, for the values in the column to WTG_1 replace the null values.
I hope you can help me
Best regards
Good morning.
I used your proposal, but I get the next problem, the first 8 data in column WTG_1 are lied to and only added from row 9 onwards.
Best regards
@Syndicate_Admin
Good Morning. I don't understand what you mean when you say "lied to".
To ensure your syntax is correct, you can use the "Conditional Column" icon in the Add Column menu
Regards,
Create a Custom Column, called something like WTG_Final using the Power Query IF function:
if [WTG] = null
then [WTG_1]
else [WTG]
Hope this works for you.
Regards,
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 |
---|---|
96 | |
94 | |
82 | |
70 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |