Forum Discussion

Rodrigo's avatar
Rodrigo
Frequent Visitor
10 years ago
Solved

How to calculate between querys

Hi Everyone,    My problem here is that on my Raw data I would like to add a column (NSAT) with the following calculation:   VerySatisifed - Somewhat Dissatisfied+ 100     Since they are ...
  • v-caliao-msft's avatar
    v-caliao-msft
    10 years ago

    Hi Rodrigo,

     

    According to your description, you need to add a calculated column to get the value from other tables, right?

     

    In DAX, we can use LOOKUPVALUE function to get the value from other table. This function returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.
    https://msdn.microsoft.com/en-us/library/gg492170.aspx

    Regards,

    Charlie Liao

Rodrigo's avatar
Rodrigo
Frequent Visitor
10 years ago

 

instead of using the mr_string_value column I am using the count column witch makes more sanse because that one does has the value but still not working. 

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
10 years ago

Hi Rodrigo,

 

According to your description, you need to add a calculated column to get the value from other tables, right?

 

In DAX, we can use LOOKUPVALUE function to get the value from other table. This function returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.
https://msdn.microsoft.com/en-us/library/gg492170.aspx

Regards,

Charlie Liao