Pivot and Null Values

[junmin]

Hi all!

I am relatively new to Power BI, and would really appreciate it if you guys could help me with this! 😞 

I have tried pivot column (Transform data -> Pivot column) on ColumnB with values from ColumnC, which actually gave me close enough to what I want but I am having problem with dealing with the null values that come with it: 

I cannot use replace null values directly because the replacement should follow the corresponding values (it has to be under the same date, and then replace the null values with the non-null value in the same column) I have also tried Fill down and Fill up for Column Question1 and Column Question3 but this will not work for Column Question2.

Should I not be using Pivot? What other solutions would you all suggest?

I hope my question makes sense!! 😞

[Anonymous · Accepted solution]

For me it worked using Pivot.
This is the data I used:

Then I used pivot column on ColumnB with values from ColumnC

And this is the result

[Tgal_van_die_1]

I don't see how this is the solution to the question

[rayzrbk · Accepted solution]

I have the same problem, and using the sum feature, I get null as my values. I start with 

And then when I pivot the Yield Item column, I get

It pulls the values for the first column, but then every other column that is added from the pivot step shows as null. Any ideas?

[Anonymous · Accepted solution]

For me it worked using Pivot.
This is the data I used:

Then I used pivot column on ColumnB with values from ColumnC

And this is the result