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 guys, thank you for taking the time to read this and helping out.
I'm having some trouble with merging the two columns together.
The attached image is of the columns in question, "gdp" and "2014 GDP, IMF.GDP"
I would like to merge the 2 columns together, keeping the the existing "gdp" value except for the 0 values, replacing the 0 values with the corresponding "2014 GDP, IMF.GDP" value.
May I know how would I go about doing that?
Thank you in advance!
Solved! Go to Solution.
You could add a custom column , something like
if [gdp] > 0 then [gdp] else [2014 gdp.........]
Hi @Djw
You can just add a conditonal column:
1. In Add column Tab find Coditional Column and follow the steps below.
replace Start date = "gdp" and End Date = "2014 GDP, IMF.GDP"
2. Remove , "gdp" and "2014 GDP, IMF.GDP" column
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Djw
You can just add a conditonal column:
1. In Add column Tab find Coditional Column and follow the steps below.
replace Start date = "gdp" and End Date = "2014 GDP, IMF.GDP"
2. Remove , "gdp" and "2014 GDP, IMF.GDP" column
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You could add a custom column , something like
if [gdp] > 0 then [gdp] else [2014 gdp.........]
Hi HotChilli, Thank you so much for your help, I hope you have a nice day ahead! Warmest regards, Djw
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |