Forum Discussion
Connect a workbook that changes name to a Power BI dataflow
Hello everyone, I have a spreadsheet that is being located in a specific folder in Sharepoint. The content of the spreadsheet is every year exactly the same, however every year this spreadsheet i...
ppm1
Solution Sage
Solution SageYou could parse the year out of the filename to create a year column, and then use the Table.Max function to keep only the latest record/row (then extract the contents of that to get your updated data).
Pat