Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
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