Forum Discussion
How do I link two columns together?
New to Power BI and I am looking to correlate some data pulled in from an API. My table, when first ingested, looks sort of like below:
The RESULTS.DATE.0 would correlate with RESULTS.VALUE.0. How would I link the two together in Power BI?
| Computer | RESULTS.DATE.0 | RESULTS.DATE.1 | RESULTS.VALUE.0 | RESULTS.VALUE.1 | RESULTS.VALUE.3 |
| COMP-4573 | 12/12/2023 | 13/12/2023 | 54638 | 5699 | 5788 |
Hi dinosainsburys ,
You have not provided a schematic of the results you are looking for, so I will give you 3 ways to do this and hope it helps. All methods will be implemented in Power Query.
1. Merge Columns:2.Pivot Column:
3.Unpivot Column(This can lead to confusing data structures):
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi dinosainsburys ,
You have not provided a schematic of the results you are looking for, so I will give you 3 ways to do this and hope it helps. All methods will be implemented in Power Query.
1. Merge Columns:2.Pivot Column:
3.Unpivot Column(This can lead to confusing data structures):
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.