Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Finding value based on row header and a column value

Good Day   I want to extract information from another table based on 2 variables. In the below data set I want to determine the "Tub Factor" column so I can multiply it by the loads. Call the below...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    HI Anonymous 
    Here is the sample file with the solution based on unpivotted table https://we.tl/t-mPd68FBRV3

     

    Tub Factor = 
MAXX ( 
    FILTER (
        RELATEDTABLE ( 'Material List' ),
        'Material List'[Fleet Size] = 'Daily Production'[Fleet Size]
    ),
    'Material List'[Value]
)

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

HI Anonymous 
Here is the sample file with the solution based on unpivotted table https://we.tl/t-mPd68FBRV3

 

Tub Factor = 
MAXX ( 
    FILTER (
        RELATEDTABLE ( 'Material List' ),
        'Material List'[Fleet Size] = 'Daily Production'[Fleet Size]
    ),
    'Material List'[Value]
)

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, thanks a lot. There seems to be something wrong with the link, it shows it has 0 files. Can you perhapse assist with sharing via another platform? 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous 
    I have updated the link in the original reply. Please check and confirm

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Works perfectly, thanks very much!