Forum Discussion

seenai's avatar
seenai
Helper II
4 years ago
Solved

Add a Column with most recent value

Hi,   I need to add a Column Like in Example. (in Power BI Query) Get the column, filled with Last Record Name in Column Base-HardenerCode Please help me with formula to add Custom Column. ...
Need Help
  • onurbmiguel_'s avatar
    onurbmiguel_
    4 years ago

    Hello 

    Sorry abouth the delay.

    My approach to you:

     

     

    if [Date] = List.Max(#"Changed Type"[Date]) then [ID] else null

    the ideia is to find do max of the date e the return de respective ID ,

     

    after you make a Fill Up, 

     

    I hope that's it

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    Best Regards
    BC

     

  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi seenai 

    Download this PBIX file with the following code

    As an alternative, you can do this in 1 line without needing to fill up:

    #"Changed Type"[#"Base-HardenerCode"]{List.Count(#"Changed Type"[#"Base-HardenerCode"])-1}

    You just need to change the reference to the previous step from #"Changed Type" to whatever the step name is before where you insert this line into your code.

    Regards

    Phil

onurbmiguel_'s avatar
onurbmiguel_
Power Participant
4 years ago

Hello, 

From your image i see that "Base-HardenerCode" is text, is there a date field to control the most recente? 

 

Best regards

BC

seenai's avatar
seenai
Helper II
4 years ago

Hi ,

Help me with formula to add Custom Column, Like in Example. (in Power BI Query)

  • Get the column, filled with Last Record Name in Column Base-HardenerCode

  •  

  • onurbmiguel_'s avatar
    onurbmiguel_
    Power Participant
    4 years ago

    Hello 

    Sorry abouth the delay.

    My approach to you:

     

     

    if [Date] = List.Max(#"Changed Type"[Date]) then [ID] else null

    the ideia is to find do max of the date e the return de respective ID ,

     

    after you make a Fill Up, 

     

    I hope that's it

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    Best Regards
    BC