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

[Anonymous]

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

[tamerj1 · Accepted solution]

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] )
)

[Anonymous]

Hi @tamerj1 

Thank you so much. I got the solution.

Best,

LCAynar

[Mahesh0016]

@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.

[Anonymous]

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!