Forum Discussion
linking data on different rows
Good afternoon, I'm new to Power BI i have cretaed a couple of display dash boards, but i'm struggling with this stage. I two columns that i want to link certain rows together. I have a slicer so w...
Hi DiperkGavin - Please share some sample data for reference and analysis on one drive.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
this is the raw data sample.
| Cost Amount | ||||||||||||||||||||||||
| No. | Location Code | Bin Code | Serial No. | |||||||||||||||||||||
| No. 2 | Description | Average Cost L | Inventory | Rem Qty | ||||||||||||||||||||
| 5162640 | Module AR - Diesel | 0.00 | 1 | |||||||||||||||||||||
| 1 | SPALDING | BIN1 | PET127451M | 0 | ||||||||||||||||||||
| Total Cost for Item | 0.00 | |||||||||||||||||||||||
| 5356925 | Tank GP-DEF (FX84309) | 0.00 | 19 | |||||||||||||||||||||
| 1 | SPALDING | BIN1 | A103827 | 0 | ||||||||||||||||||||
| 1 | SPALDING | BIN1 | A104366 | 0 |
this is how it then uploads into the transform data page.
this is how it then looks in the visual table page.