Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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] )
Solved! Go to Solution.
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
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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |