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

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
Icon for Memorable Member rankMemorable 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