Forum Discussion

Blake753's avatar
Blake753
Helper II
4 years ago
Solved

Retrieve value from same row based on value in column

I am looking to build a calculated column that pulls its data from one of two other columns based on the value in a third column.  Example would be: 

PhaseVolume1Volume2Calculated Column
0234545
1404
2404
3202

 

If the "Phase" column equals 0, then I want the volume in the "Volume2" column.  If the "Phase" column is greater than 0, then I want the volume in the "Volume1" column.  Thank you in advance.

IF THEN ELSE
  • Blake753's avatar
    Blake753
    4 years ago

    Figured it out pretty easily, 

     

    Volume =
    if(
    'PME Inventory Snapshot'[Phase]<>0,
    'PME Inventory Snapshot'[valid],
    'PME Inventory Snapshot'[ref_cnt]
    )
     
    Thanks 

1 Reply

  • Blake753's avatar
    Blake753
    Helper II
    4 years ago

    Figured it out pretty easily, 

     

    Volume =
    if(
    'PME Inventory Snapshot'[Phase]<>0,
    'PME Inventory Snapshot'[valid],
    'PME Inventory Snapshot'[ref_cnt]
    )
     
    Thanks