Forum Discussion

key_to's avatar
key_to
Advocate I
3 years ago
Solved

help creating a variable

Hello!  I have a simple table with 'end of year' date, org unit and number of employees - see screenshot. I would like to convert all the numbers in the table below into variables so that I can use ...
Need Help
  • key_to's avatar
    key_to
    3 years ago

    Hi and thanks to you both for putting me on a right path!

    I was probably just thinking to complicated.  I wanted to be able to refer to the number from the table through variable and I think I achieved it simply with the calculate function: 

     

    This looks correctly when testing. Now it remains to see whether I get the right results in my calculation of turnover and growth 🙂 

v-yinliw-msft's avatar
v-yinliw-msft
Community Support
3 years ago

Hi key_to ,

 

Could you please tell me more about your purpose of converting numbers to variables?

What do you want to calculate?

But the function SUMX needs two parameters and the first parameter needs to be a table:

SUMX function (DAX) - DAX | Microsoft Learn

You can refer this documentation.

 

Hope this helps you.

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.