Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
hi everyone,
i have a problem with replacing null values with content from other column. The scenerio is something like this. let say i have three columns A,B,C
A | B | C |
X | 10 | 10 |
X.1 | null | 10 |
X.2 | null | 10 |
Y | 11 | 11 |
Y.1 | null | 11 |
Y.2 | null | 11 |
C is my custom column created based on data from two columns A and B. please help with the query to construct above scenario.
Thanks,
Sivaaprataap.
Solved! Go to Solution.
On "Add Column" tab duplicate column B to C
On "Transform" tab select column C, then option "Fill" - "Fill Down".
Looks like Column A is not required to determine the values in column C.
On "Add Column" tab duplicate column B to C
On "Transform" tab select column C, then option "Fill" - "Fill Down".
Looks like Column A is not required to determine the values in column C.
Hi Marcel,
Thanks for the help. It means a lot.
Regards,
Sivapratap
User | Count |
---|---|
82 | |
72 | |
67 | |
47 | |
36 |
User | Count |
---|---|
111 | |
56 | |
50 | |
42 | |
40 |