Forum Discussion
Solved
How To Collate Tables
Hi guys, can anyone advise the process to generate one big table from a bunch of little tables where rows are in the exact same order as the original tables? I've spent 3 full days trying to get ...
The index column has the wrong datatype. It's set as decimal number, it should be whole number. And it should be set as 'do not summarize.'
Make that change on each of the three 'Grab ....' tables
You'll probably need to change the visualisations as well. Set the Index in Values to 'Don't summarize'
HotChilli, I can't thank you enough. I've spent 3 days on this and you've just fixed it in seconds with your beautiful brain. Thank you so much! :smileyvery-happy:
I left the Index column as decimal format because that was the default setting for an index column which seems strange, again thank your brain for me.
Happy to help.
The question was clear (with picture and pbix) and that makes it a lot easier to investigate.