Forum Discussion
Solved
Merge and Collate Data correctly
Hi, I am fairly new to PowerBI and ive been struggling to try and get the correct data, i feel like i am going in the right direction but i need some assistance. I have a Data Query that pull...
to know how to do this watch my video and pbix File
List.Generate(()=>[DATEUSED], (x)=> x<=[DATERETURNED], (x)=> Date.AddDays(x,1))
But if each ITEM is added as its own column
why do you have them separately and how is it I don’t understand
Sorry.
Following your video.
Pivoting on the ITEM column adds each ITEM as its own column into the table.