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
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 because
| B-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-09pls try this