Forum Discussion
Filter ticket column based on last update
I've added in the necessary steps to your query. I didn't change your Source location as I aded the files to my PC in the same path.
After the Grouped Rows step, I manually entered the Merge step. This merges the #"Grouped Rows" step with the table that results from the step immediately above it, #"Removed Columns".
The result is a table with just the Latest Updated rows.
Regards
Phil
Not really sure what you are hoping for. Sounds like you want to modify your source data, rather than do any filtering within PBI?
Not sure how I could modify your source data from outside PBI? What do you mean by modify my query to change my dataset automatically
What query are you referring to?
If you bring this dataset into PBI you can create a table and then show the MAX date for each Ticket ID.
Regards
Phil
I'd like to filter within PBI but as close to the source as possible.
You talk about "show the MAX date for each Ticket ID"... how can I do that?
And what if my data comes from a folder with a couple of CSV's in it?
All CSV's contain the same structure but with different data. (that why I want to sort for last update)Hi,
Share the link from where i can download your Excel file.
