AddColumn

[FZOU]

Hello,

I created a table with the following formula : 

Excess Stock FY =

GROUPBY (ADDCOLUMNS(DimDate,"Excess Stock",[Excess Stock]),

DimDate[FY],DimDate[FYDate],DimDate[Index],

"Excess Stock",

sumx(CURRENTGROUP(),[Excess Stock]))

which gave me this table : 

what i want to do and i can't achieve it is to add 3 more columns to this table from 3 dimensions: Product(ID),Region(ID),Team(ID), any idea please ? thank you 🙂

[AllisonKennedy]

@FZOU  What are your relationships between tables please? And what is the purpose of this table? Can you acheive the same using a table visual in the report?

[FZOU]

@AllisonKennedy  I can't achieve what i want with a table visual i need to create this new one, for the moment there is no relation between tables,that's why i need to add those 3 columns to make relationship with other dimension.

[AllisonKennedy]

@FZOU  Can you share sample of what your data looks like? we don't have enough info to go on to help you and need to understand how the data is related (even if there's no physical relationship) so that we can help you build the right formula.

[FZOU]

@AllisonKennedy i'm sorry i can't share a sample of data,i'm just looking to how add columns in my table inside or outside the mentionned formula

[AllisonKennedy]

@FZOU  You don't need to share the actual data, but you can't create columns in the formula so we need to know what format they are in currently and how to connect them to the existing table within the formula. If there is no connection, you won't succeed with the formula so need to find the keys that relate your data:

https://excelwithallison.blogspot.com/search?q=relationships+it%27s+complicated