Forum Discussion
Solved
How to fill missing value based on Primary key values in Power BI
Hi everyone, I have a data which appears like below:
| Id | Category | Gender | Output |
| 1 | Test1 | M | M |
| 1 | Test2 | M | |
| 2 | Test1 | F | F |
| 3 | Test1 | F | F |
| 3 | Test1 | F | F |
| 3 | Test2 | F | |
| 4 | Test1 | M | M |
| 4 | Test2 | M | |
| 4 | Test2 | M |
Output column is my expected output and Id column is like my primary key.
For category = Test1 there are values however for category = Test2 values are missing in gender columns.
I need to know how I can print the same output based on Id column.
Any help would be appreciated.
Thanks in Advance.
pls try this
1 Reply
- Ahmedx
Super User
pls try this