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
I have two columns like below. The main data I want to use is from Column B, however when column B has a blank I want to use the data in the corrosponding cell in column A so I end up with column C. Is this possible, thanks in advance
A | B | C |
Green | Green | |
Blue | Blue | |
Red | Red | |
Yellow | Yellow | |
Pink | Pink | |
Black | Black | |
Purle | Purle | |
Orange | Orange |
Solved! Go to Solution.
In Power Query this is a pretty simple if [column b] <> "" then [column b] else [column a], DAX would be similar
In Power Query this is a pretty simple if [column b] <> "" then [column b] else [column a], DAX would be similar
Hello - would you have suggestion if i have more than 2 columns? Thanks!
@jthomson sorry i put this as solved but it is not working. When i put in the "" it doesnt work with the measure
thanks
Maybe try null instead dependent on how exactly your data handles blanks
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |