Forum Discussion
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.
Hello
Sorry abouth the delay.
My approach to you:
if [Date] = List.Max(#"Changed Type"[Date]) then [ID] else nullthe 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
BCHi 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
6 Replies
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
It works as required. Great Support.
Thank You Very much.
Hello,
From your image i see that "Base-HardenerCode" is text, is there a date field to control the most recente?
Best regards
BC
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
Hello
Sorry abouth the delay.
My approach to you:
if [Date] = List.Max(#"Changed Type"[Date]) then [ID] else nullthe 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
- Get the column, filled with Last Record Name in Column Base-HardenerCode
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
