Forum Discussion
How To Collate Tables
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'
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.