Retrieve value from same row based on value in column

[Blake753]

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
0	23	45	45
1	4	0	4
2	4	0	4
3	2	0	2

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.

[Blake753 · Accepted solution]

Figured it out pretty easily, 

Volume =

if(

'PME Inventory Snapshot'[Phase]<>0,

'PME Inventory Snapshot'[valid],

'PME Inventory Snapshot'[ref_cnt]

)

Thanks