Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Like this?

Column3 = IF(LEN([Column1])=6,[Column1],[Column2])
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Greg_Deckler Thanks for your answer. Would you do this as a new add'ed column in the query editor? I get the error that "IF"-function is not known here?