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))
show me what your table looks like so I can understand what you need
Thank You.
This is essentially the output table i am trying to get:
With the ability to filter on the item.
But if each ITEM is added as its own column, would i need to aggregate all of these columns into a single column so that i can filter them?