Forum Discussion
Split column by delimeter and return column with latest date
Hello, I have a user submitted text field in SharePoint, called Notes, in my dataset, and I am looking to always return the latest note in any row. The Notes field is always split by a semicolon ...
Hi jbwtp , I'm not able to get that to work by adding it in as a customer step in Power Query. Mayube worth mentioning that my "Report Name" field is actually called "Title" in my dataset, would this effect the code you posted? Thanks for the help so far!
Hi troyphillips,
The line that you need is this one:
,
#"Added Custom" = Table.AddColumn(PlacePreviousStepNameHere, "Automated", each List.Last(Text.Split([Notes], "
")))
in
#"Added Custom"Replace the closing "in YourLastStep" in your code with the above and change the PlaceYourPreviousStep tag to the actual name of the previous step and [Notes] to what is your actual field name for notes.
Cheers,
John