Is it posibble to create a personalized column sellecting values from another 2 columns?

[Maricel]

Hello,

I have 2 diferents columns  in a table, indicating the amount of minimiun stock: one has the data

from the ERP (1st column) and the other column has the minium stock calculated using a DAX formula (2nd column).

Some of my products do not have indicated the amount of minium stock allowedi n de ERP , and there is when I want to use the value generated with DAX.

Is it posible to create a personalized column that takes the value in de ERP column (1st column) (if there is any number) and add the value in a new column (the personlized one, 3rd column) and, if the value in the ERP is empty, then takes de value in the DAX column (2nd column) and add this value to the 3rd column?

An example:

1. ERP stock Min	2. DAX Stock Min	3. Personalized
50	45	50
	89	89
	150	150
65	100	65

Help please!

[ERD · Accepted solution]

@Maricel ,

you need a calculated column, correct? If so, your approach:

IF( Table[column1] = BLANK(), Table[column2], Table[column1] )

If you work with measures:

Measure = IF(MAX(Table[Column1]) = BLANK(), [Measure 2], MAX(Table[Column1]))

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.