Forum Discussion

mahra-in's avatar
mahra-in
Helper II
8 years ago
Solved

multiply when a match between two tables

Hi   I have    Table 1   Name Year Subject Weightage Alan 2016 CCA 0.1 Donal 2016 PPP 0.2 Dhoni 2017 SCA 0.15 Ram 2018 SSS 0.12 Siva 2018 SSS 0.18   Tab...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi mahra-in

     

    Please add the following calculated column to your 'Table 2'

     

    Weighted Spend = 
    'Table 2'[Spend] * 
     CALCULATE(
        MIN('Table 1'[Weightage]),
        FILTER(
            'Table 1',
            'Table 1'[Name] = EARLIER('Table 2'[Name]) &&
            'Table 1'[Year] = EARLIER('Table 2'[Year]) 
        )
        )

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi mahra-in

 

Please add the following calculated column to your 'Table 2'

 

Weighted Spend = 
    'Table 2'[Spend] * 
     CALCULATE(
        MIN('Table 1'[Weightage]),
        FILTER(
            'Table 1',
            'Table 1'[Name] = EARLIER('Table 2'[Name]) &&
            'Table 1'[Year] = EARLIER('Table 2'[Year]) 
        )
        )

  • mahra-in's avatar
    mahra-in
    Helper II
    8 years ago

    thank u