Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |