Power BI Exchange

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



  • 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
    ------------------------------