topic Re: The column specified in the Groupby function was not found in the input table in DAX Commands and Tips

The column specified in the Groupby function was not found in the input table

Anonymous — Mon, 02 Jan 2023 05:00:03 GMT

Dear Team,

I would seek the supproting, i have three relationship tables, when I groupby to get relevant column and got message stated that "The column "Item Code" specified in the Groupby function was not found in the input table"

I am appreciated for helping

Thanks , LC Aynar

Re: The column specified in the Groupby function was not found in the input table

Mahesh0016 — Mon, 02 Jan 2023 05:35:41 GMT

Anonymous
Good Morning,

Anonymous You should use one table column in Groupby that's why Dax give you error.
Agents[No_],items["Item Code"] both columns are belong to different table .

*If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

Re: The column specified in the Groupby function was not found in the input table

Anonymous — Mon, 02 Jan 2023 06:13:07 GMT

Good Morning Mahesh0016 ,

Thanks for your guidance. But I aim to do goupby to get some columne name from another table for computing. Is there any solution to do this.

Thanks!

Re: The column specified in the Groupby function was not found in the input table

tamerj1 — Mon, 02 Jan 2023 07:19:50 GMT

Hi Anonymous
You can use SUMMARIZE to create the new calculated table

SalesInventorySummary = SUMMARIZE ( InventoryMovement, InventoryMovement[Posting Date], InventoryMovement[Document No_], InventoryMovement[Agent Code], InventoryMovement[Item No_], Agents[No_], Items[Item Code], "OrderQty", SUM ( InventoryMovement[Quantity] ) )

Re: The column specified in the Groupby function was not found in the input table

Anonymous — Mon, 02 Jan 2023 07:55:03 GMT

Hi tamerj1

Thank you so much. I got the solution.

Best,

LCAynar