Forum Discussion
Fcoatis
Post Patron
Post PatronADDCOLUMNS
I need help with this one: Can I calculate a third column from the two just created? Category Budget =
ADDCOLUMNS(
CROSSJOIN(SUMMARIZECOLUMNS('Product Category'[Category]);DISTINCT('D...
Hi Fcoatis
Yes, you just need an additional ADDCOLUMNS:
Category Budget = ADDCOLUMNS ( ADDCOLUMNS ( CROSSJOIN ( SUMMARIZECOLUMNS ( 'Product Category'[Category] ); DISTINCT ( 'Date'[Month] ) ); "2009 Sales"; CALCULATE ( [Sales Amount]; 'Date'[Calendar Year Number] = 2009 ); "Factor"; LOOKUPVALUE ( 'Product Category'[Budget]; 'Product Category'[Category]; [Category] ) ); "Extra column"; [Factor] * [2009 Sales] )I've set the product of the two columns as example
AlB
Community Champion
Community ChampionHi Fcoatis
Yes, you just need an additional ADDCOLUMNS:
Category Budget =
ADDCOLUMNS (
ADDCOLUMNS (
CROSSJOIN (
SUMMARIZECOLUMNS ( 'Product Category'[Category] );
DISTINCT ( 'Date'[Month] )
);
"2009 Sales"; CALCULATE ( [Sales Amount]; 'Date'[Calendar Year Number] = 2009 );
"Factor"; LOOKUPVALUE (
'Product Category'[Budget];
'Product Category'[Category]; [Category]
)
);
"Extra column"; [Factor] * [2009 Sales]
)
I've set the product of the two columns as example
