Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Changing column names

Hi   I'm trying to run the following code but DAX complains that both tables have the same column names, named "Value".   I tried to rename the column in one of the tables with the SELECTCOLUMNS ...
Need Help
Show and Tell
  • HotChilli's avatar
    HotChilli
    7 years ago

    I got the answer from stackoverflow.  I had an alternative with addcolumns but this is much simpler.

     

    Table x = VAR _numberTab = SELECTCOLUMNS ( GENERATESERIES ( 1, 60 ), "number", [Value] )              
          VAR _valuesTab = GENERATESERIES(CURRENCY(100), CURRENCY(100))
RETURN 
      CROSSJOIN(_numberTab,  _valuesTab)

     

     

HotChilli's avatar
HotChilli
Community Champion
7 years ago

I got the answer from stackoverflow.  I had an alternative with addcolumns but this is much simpler.

 

Table x = VAR _numberTab = SELECTCOLUMNS ( GENERATESERIES ( 1, 60 ), "number", [Value] )              
          VAR _valuesTab = GENERATESERIES(CURRENCY(100), CURRENCY(100))
RETURN 
      CROSSJOIN(_numberTab,  _valuesTab)

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HotChilli thank you