79357018

Date: 2025-01-15 03:48:22
Score: 0.5
Natty:
Report link

Found a solution by going to "Transform Data" and changing the "Source" code to dynamically get the last value in reviews.

= Python.Execute("#(lf)def extract_findings(filename):#(lf)    
...

#(lf)filename = "&"""" &Record.Field(Table.FirstN(Table.Sort(reviews, 
{{"createdon", Order.Descending}}), 1){0}, "attachment")& """"&"#(lf)
findings_df = extract_findings(filename)#(lf)
findings_df"
)
Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: carly m