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!

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , how are you moving data from one table/dataset to another. The few ways are

//In dataset 1 from dataset 2

//when Dataset 1 and dataset 2 has Many to 1 reation

New colum dataset 1 = dataset1[price]*0.5* RELATED('dataset2'[Fee])

 

//In dataset 1 from dataset 2

//when Dataset 1 and dataset 2 has Many to 1 reation why giving a key column

Month Name = dataset1[price]*0.5*  LOOKUPVALUE('dataset2'['dataset2'[Fee],'dataset2'[key],'dataset1'[key])

 

 

//any direction just take care of filter join and aggeragtion - minx,maxx,xountx,sumx

New in dataset 1 =dataset1[price]*0.5*    maxx(FILTER(dataset2,dataset2[Id]=dataset1[Id]),'dataset2'[Fee])