Forum Discussion

marcomartinetti's avatar
marcomartinetti
Regular Visitor
3 years ago

Insert New column using values from another column - Power BI Desktop

Hi communuty, I would need a hand to figure out how to create a new column in an existing table by taking data from another table. I tried to use the formula :  CMP = var article code = Vendi...
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

marcomartinetti I hope this helps you!Thank You!!
CREATE Column :
CMP = lookup([VALORENETTOSCHEDA],[Articolo],[K_CodArt])

  • marcomartinetti's avatar
    marcomartinetti
    Regular Visitor
    3 years ago

    oh wow ok! I had never used this feature.

    but this feature is fine even if I have to use a double filter? item code and date? or is it just fine with a filter?

    • Mahesh0016's avatar
      Mahesh0016
      Icon for Super User rankSuper User
      3 years ago

      marcomartinetti Yes , you can use in calculate function then apply filter.
      For E.g
      CMP = calculate(lookup([VALORENETTOSCHEDA],[Articolo],[K_CodArt]), filter(conditions)).

      marcomartinetti THANK YOU!!