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

  • 1.  Need latest text in colmn from multiple available values (snapshot included)

    Bronze Contributor
    Posted 24 days ago
    Hi guys,
    I have 2 tables. Both have a common colmn id.
    I want to populate in table 2 with reasons from Table-1. 

    But bcoz there are no of reasons available in table-1, i want the latest one available.
    Pls GUIDE






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


  • 2.  RE: Need latest text in colmn from multiple available values (snapshot included)

    Posted 23 days ago
    Edited by Vilmar Santos 23 days ago
    Veja se ajuda
    Column1 = 
MAXX (
    FILTER (
        SUMMARIZE (
            Table1,
            Table1[Id],
            "@Reasons",MAX ( Table1[Reasons] ),
            "@updateAt", MAX ( Table1[updateAt] )
        ),
        [Id] = Table2[Id]
    ),
    [@Reasons]
)​

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

    Original Message


  • 3.  RE: Need latest text in colmn from multiple available values (snapshot included)

    Bronze Contributor
    Posted 23 days ago

    Isso ajudou . Obrigado

    Thanks a lot sir for your help. Works



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

    Original Message