combine two column
1 Topic
Combine two columns from different tables in SSAS Tabular with DAX
Hi All, I try to Combine two columns from different tables in SSAS Tabular with DAX. I had the follow code to get the two columns =VAR A = CALCULATETABLE( SUMMARIZE(StockDetail,StockDetail[ProductCode]),FILTER(RELATEDTABLE(Product),Product[code])) VAR B =CALCULATETABLE( SUMMARIZE(Product,Product[code]),FILTER(RELATEDTABLE(StockDetail),StockDetail[ProductCode])) VAR result = A RETURN result At moment I only have one column, I would like to have a bridge table with the two columns "StockDetail[code]" and "product[code]". thanks, pmSolved2.6KViews0likes6Comments