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.
Hello. I am working on DAX, and want to define three variables and then sum all of them. Here is my code:
/*VARIABLE DEFINITION*/ VAR ventashrs=SUM(UTILIDADES[Ventas Waldbott HORAS]) VAR ventasprod=SUM(UTILIDADES[Ventas Waldbott SOFT]) VAR ventasmod=SUM(UTILIDADES[Ventas. Mod.]) /*FORMULA*/ ventashrs+ventasprod+ventasmod
I am getting a weird "The syntax for "(" is incorrect" error for apparently no reason. I checked the formula several times. What am I missing?
Thanks in advance.
Solved! Go to Solution.
After you have declared your variables you need to type RETURN in order for the calculation to proceed.
Br,
Magnus
After you have declared your variables you need to type RETURN in order for the calculation to proceed.
Br,
Magnus
Thank you very much, my friend.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |