Forum Discussion
Merging two columns by criteria
Hi everyBI'ers Q: How do I merge two columns by the criteria that the values from column1 and colum2 is evaluated by it's number of digits? Example: I would like to merge the following two c...
HI Anonymous,
You can try to use below formula:if [Column1] >= 100000 then [Column1] else if [Column2] >= 100000 then [Column2] else null
In addition, you can also use Number.From function to convert result from mals's formula.
Regards,
Xiaoxin Sheng
MalS Thanks for your answer, but then columns has to be converted to text, isn't it possible to do the same operation with number-columns?
HI Anonymous,
You can try to use below formula:
if [Column1] >= 100000 then [Column1] else if [Column2] >= 100000 then [Column2] else null
In addition, you can also use Number.From function to convert result from mals's formula.
Regards,
Xiaoxin Sheng