Forum Discussion
How to replace SELECTCOLUMNS in a DAX query ?
Hi experts,
After several search at home, I've been able to write the following DAX code to calculate loads per quarter per item and step. It works and gives me the expected results.
But back to my office it didn't work. Thanks to the error message, I realized that "SELECTCOLUMNS" does not exist on excel 2013 !
I don't find yet the way to replace this fonction ; could you help me ?
Thanks by advance.
EVALUATE
SELECTCOLUMNS(
FILTER(
CROSSJOIN(ProcessSheet, ForecastPerProgram),
ProcessSheet[program]=ForecastPerProgram[program]
),
"program", ProcessSheet[program],
"YYYYQQ", RELATED(quarters[YYYYQQ]),
"load", [load],
"item", ProcessSheet[item],
"step", ProcessSheet[step],
"WorkCenter", ProcessSheet[WorkCenter]
)- [load] is a mesure =AVERAGE(ProcessSheet[LoadPerUnit])*AVERAGE(ForecastPerProgram[QtyPerQuarter])
- ProcessSheet is a table which gives the time ("LoadPerUnit") needed to produce one item for each step on associated workcenter. At each item is associated a program
- ForecastPerProgram is a table which gives forecasts per program and per quarters
Hi arq52 ,
You can use summarize() or addcolumns() to replace selectcolumns.
Please refer to: https://msdn.microsoft.com/en-us/query-bi/dax/addcolumns-function-dax and
https://msdn.microsoft.com/en-us/query-bi/dax/summarize-function-dax
Regards,
Jimmy Tao
1 Reply
- v-yuta-msft
Community Support
Hi arq52 ,
You can use summarize() or addcolumns() to replace selectcolumns.
Please refer to: https://msdn.microsoft.com/en-us/query-bi/dax/addcolumns-function-dax and
https://msdn.microsoft.com/en-us/query-bi/dax/summarize-function-dax
Regards,
Jimmy Tao