Forum Discussion

arq52's avatar
arq52
Frequent Visitor
8 years ago
Solved

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