jimrward
Well-known Member
- Joined
- Feb 24, 2003
- Messages
- 1,896
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
historically i have a large data set from which I have created lots of sub queries and everything is working fine
my current issue is as follows
I created a small table on a worksheet with some lookup values and gave it a name PaperCount, this table has a name in column 1 and count in column 2
in one of my existing queries I want to reference this table and pick up the value according to the name and get the value
adding custom columns with
if List.PositionOf(PaperCount[UniqueNames],[SName]) = -1 then 0
else PaperCount[Total]{List.PositionOf(PaperCount[UniqueNames],[SName])}
I keep getting an error "The name PaperCount wasnt recognised"
my current issue is as follows
I created a small table on a worksheet with some lookup values and gave it a name PaperCount, this table has a name in column 1 and count in column 2
in one of my existing queries I want to reference this table and pick up the value according to the name and get the value
adding custom columns with
if List.PositionOf(PaperCount[UniqueNames],[SName]) = -1 then 0
else PaperCount[Total]{List.PositionOf(PaperCount[UniqueNames],[SName])}
I keep getting an error "The name PaperCount wasnt recognised"