Forum Discussion
Is it posibble to create a personalized column sellecting values from another 2 columns?
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!
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.
1 Reply
- ERD
Community Champion
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.