Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

undefined

Hey guys, I need to create a column in my powerbi table (powerquery) with the following condition If "brand" column is = "PEUGEOT" AND "CITROEN" then get the position from 1 to 3 ELSE positio...
Need Help
  • jbwtp's avatar
    jbwtp
    3 years ago

    Hi Anonymous,

     

    Do you mean something like:

    Source = FatorequisicaoDetalhe

    Or if the table/query name has spaces or special characters:

    Source = #"FatoRequisicaoDetalhe"

    Kind regards,

    John

jbwtp's avatar
jbwtp
Memorable Member
3 years ago

Hi Anonymous,

 

This can be done through the AddColumn menu in PBI Power Query Editor.

This is not clear, however, what do you mean by "get the position from 1 to 3"?

 

Cheers,

John

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I have a field called Chassis, in position 1 to 3 I can identify the Peugeot and Citroen models, in position 4 to 6 I have the other manufacturers, I could do this separately, but I would need to duplicate the field and apply this rule , the question is can I do this only once, with one condition?

    • jbwtp's avatar
      jbwtp
      Memorable Member
      3 years ago

      Hi Anonymous,

       

      Do you mind visualising what you are saying with a couple of screenshots or tables, so it was clear where do you start and what are you trying to achieve?

       

      Thanks,

      John