Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How do multiple a variables in one data source, and one other in an other data source

Hello, I wonder.. I have a parameter that i wanna mulitiple. with another parameter in anohter data set, how do I do that?    Dataset1           Dataset2 a                      b   and the fo...
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    You may try a method below if  the two datasets dont have a relationship between:

    First in both datasets,create an index column;

    Then create a column as below:

    Column = 'Table 1'[Value]*0.5*CALCULATE(MAX('Table 2'[Value]),FILTER('Table 2','Table 2'[Index]='Table 1'[Index]))

    For details ,pls see attached.

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

     

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ，

 

You may try a method below if  the two datasets dont have a relationship between:

First in both datasets,create an index column;

Then create a column as below:

Column = 'Table 1'[Value]*0.5*CALCULATE(MAX('Table 2'[Value]),FILTER('Table 2','Table 2'[Index]='Table 1'[Index]))

For details ,pls see attached.

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!