Discussions – Power Platform – Dynamics Communities

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

Power Platform

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

Posted by DSC Communities on January 10, 2023 at 6:14 am
- Bhupendra Mishra
  
  Member
  
  January 10, 2023 at 6:14 AM
  
  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
  ——————————
- Vilmar Santos
  
  Member
  
  January 10, 2023 at 1:38 PM
  
  Veja se ajuda
  
  Column1 = MAXX ( FILTER ( SUMMARIZE ( Table1, Table1[Id], "@Reasons",MAX ( Table1[Reasons] ), "@updateAt", MAX ( Table1[updateAt] ) ), [Id] = Table2[Id] ), [@Reasons] )?
  
  ——————————
  Vilmar Santos
  ——————————
  ——————————————-
- Bhupendra Mishra
  
  Member
  
  January 11, 2023 at 12:21 AM
  
  Isso ajudou . Obrigado
  
  Thanks a lot sir for your help. Works
  
  ——————————
  Anubhav Mahule
  Lead consultant
  ——————————
  ——————————————-
DSC Communities replied 2 years, 8 months ago 1 Member · 0 Replies
0 Replies

Sorry, there were no replies found.

The discussion ‘Need latest text in colmn from multiple available values (snapshot included)’ is closed to new replies.