Forum Discussion
Merge and Collate Data correctly
to know how to do this watch my video and pbix File
List.Generate(()=>[DATEUSED], (x)=> x<=[DATERETURNED], (x)=> Date.AddDays(x,1))
This is amazing, thank you.
I've come across a few potential issues with this method though.
There are a total of around 600+ items, meaning that each item needs to be manually added to the table as a column, and new items will also have to be manually added.
- Ive tried merging these into their own table so it can be used for filtering etc, however again each column needs to be typed manually to merge?
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?But if each ITEM is added as its own column
why do you have them separately and how is it I don’t understand