Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

View My Drafts

Back to discussions
Expand all | Collapse all

Want 1st value from Lookup value from duplicate values

  • 1.  Want 1st value from Lookup value from duplicate values

    Bronze Contributor
    Posted Dec 19, 2022 02:31 AM
    Hi GUys,

    I have 2 tables with common ID, i want to create a new colmn/measure from lookup in one of the colm, but there are multiple values from another colmn, i want the 1st result to appear only.. how can i do it?

    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------


  • 2.  RE: Want 1st value from Lookup value from duplicate values

    Posted Dec 19, 2022 03:44 PM
      |   view attached
    Veja se o anexo ajuda.

    • No Power query foi adicionado uma coluna índice
    • No DAX foi utilizado a LOOKUPVALUE



    ------------------------------
    Vilmar Santos
    ------------------------------

    Attachment(s)

    pbix
    Test.pbix   30 KB 1 version
    Original Message