Forum Discussion
Solved
Need to Transform Data In Power BI
I've Imported Data from Databricks to Power BI. The data seems to look like Below. batchid sampleid REPLICATEID CreateDate Thickness Dry Wet Mixed B-20231006-0039 S-20231009-0179 1...
pls try this
what should be the result? such
In Null value must be 45.09 you pointed.
explain why it should be this way and on what basis
If you see last three four rows data
B-20231006-0039 S-20231009-0179 2 2023-10-09 NULL 45.09 NULL NULL B-20231006-0039 S-20231009-0179 2 2023-10-09 22.09 NULL NULL NULL B-20231006-0039 S-20231009-0179 2 2023-10-09 NULL NULL 34.23 NULL B-20231006-0039 S-20231009-0179 2 2023-10-09 NULL NULL NULL 42.44
I need out like this becauseB-20231006-0039 S-20231009-0179 2 2023-10-09 22.09 45.09 34.23 42.44 I will reduce the number of rows
batch ID -
B-20231006-0039
SampleID - S-20231009-0179ReplicateID - 2
Createdate- 2023-10-09