Add a Column with most recent value

[seenai]

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.
  
  

[onurbmiguel_ · Accepted solution]

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

[v-easonf-msft]

Hi,  @seenai 

Could you please tell me whether your problem has been solved?

For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[PhilipTreacy · Accepted solution]

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

[seenai]

It works as required. Great Support.

Thank You Very much.

[onurbmiguel_]

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]

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_ · Accepted solution]

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