Retrieve value from same row based on value in column

Blake753 — Tue, 11 Jan 2022 17:02:42 GMT

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.

Re: Retrieve value from same row based on value in column

Blake753 — Tue, 11 Jan 2022 17:16:05 GMT

Figured it out pretty easily,

Volume =

if(

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

'PME Inventory Snapshot'[valid],

'PME Inventory Snapshot'[ref_cnt]

)

Thanks

topic Re: Retrieve value from same row based on value in column in DAX Commands and Tips

Retrieve value from same row based on value in column

Re: Retrieve value from same row based on value in column