Forum Discussion
Cyclic reference error
Hi Anonymous,
AFAIK, the second parameter of 'Table.SelectColumns' function is a list of string values. But the parameter which you provide seems like inputted a list with multiple list values in it.
Maybe you can try to use following formula to replace original one or add list index to return specific row from that list.
Get_core_fields = Table.SelectColumns(Filter_for_Work_Resources_who_are_Users,{"ResourceId", "ResourceCreatedDate", "ResourceEmailAddress", "ResourceName", "TeamName", "ResourceDepartments"})Get_core_fields = Table.SelectColumns(Filter_for_Work_Resources_who_are_Users,{Resources[ResourceId]{0}, Resources[ResourceCreatedDate]{0}, Resources[ResourceEmailAddress]{0}, Resources[ResourceName]{0}, Resources[TeamName]{0}, Resources[ResourceDepartments]{0}})BTW, can you please provide more info about 'resource'? I'm not so clear for it.
If it is reference from current query table, you will faced cycle reference issue when you use the reference query table to calculate with current query table.Regards,
Xiaoxin Sheng
Hi Anonymous,
AFAIK, the second parameter of 'Table.SelectColumns' function is a list of string values. But the parameter which you provide seems like inputted a list with multiple list values in it.
Maybe you can try to use following formula to replace original one or add list index to return specific row from that list.
Get_core_fields = Table.SelectColumns(Filter_for_Work_Resources_who_are_Users,{"ResourceId", "ResourceCreatedDate", "ResourceEmailAddress", "ResourceName", "TeamName", "ResourceDepartments"})
Get_core_fields = Table.SelectColumns(Filter_for_Work_Resources_who_are_Users,{Resources[ResourceId]{0}, Resources[ResourceCreatedDate]{0}, Resources[ResourceEmailAddress]{0}, Resources[ResourceName]{0}, Resources[TeamName]{0}, Resources[ResourceDepartments]{0}})
BTW, can you please provide more info about 'resource'? I'm not so clear for it.
If it is reference from current query table, you will faced cycle reference issue when you use the reference query table to calculate with current query table.
Regards,
Xiaoxin Sheng
Hi Anonymous
Thankyou, the first option worked and gave me a tabe with the named columns in it. I also tried the second option, but that returned the cyclic reference error.
As to Resources, it is a table in MS Project, containing rows for each resource name in the enterprise resource table.
Thanks again for your help.
One final (for now) question, is there any good reference material that will assist my coding ?
Rgds
Fred