'SUMMARIZECOLUMNS handling multiple columns with the same name
For debugging purpose I want to create a DAX table using SUMMERIZECOLUMNS fuction which selects the same column names of two different tables.
Tab = SUMMERIZECOLUMNS ( Sales[Product_ID], Product[Product_ID] )
It raises an error:
The Column with the name of 'Product_ID' already exists in the 'Tab' Table
Replacing Product[Product_ID] with: SELECTCOLUMNS( Product, Product[Product_ID] ) does not solve the problem as it produces error:
A single value for column 'Product[Product_ID]' in table 'Product' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|