Forum Discussion

Wilsonr's avatar
Wilsonr
Icon for Helper I rankHelper I
8 years ago

SELECTCOLUMNS - Issue when Using a Measure

I am using SELECTCOLUMNS create a new table called "My_Table" from an existing table called "Dedicated_Measures". I want to recover the "Week", "Product" and "Value" columns for a given week, i.e. 20...
Need Help
Wilsonr's avatar
Wilsonr
Icon for Helper I rankHelper I
8 years ago

Dale,

 

I spoke too soon in my reply below - removing the ALL() makes no difference. So while SELECTCOLUMNS doesn't work, SUMMARIZE works.

 

I wanted to attach the file, but can't find a way to do so.

Thanks in advance,

Ron

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Ron,

 

You can upload the file to the cloud service like OneDrive, GoogleDrive then share the download link here. 

It seems something wrong with your data structure.

 

Best Regards,

Dale