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:  Phase Volume1 Volume2 Calculated Column ...
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 
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