File based calculation query

[Dorian_scr]

Hello

I created a database made up of CSV. The files are all combined into a single table. I have in this table, calculated some differences between some columns however since my files are combined this calculate between all the data of all the files. I would like to be able to restrict these calculations to only data that comes from the same file. To do this, I will need to add a filter at the start of my formulas to matches the lines that have the file name in common (the first column of my table).

I performed all my calculations in Power Query and I don't find how to filter.

here a example of a line :

([S3_MS] - List.Min(#"Type modifié1"[S3_MS]))/1000)

[AllisonKennedy · Accepted solution]

@Dorian_scr If I understand correctly, I could do so in the auxiliary query. There must be a 'Transform sample file' query or something similar that works with each CSV file by itself - add the List.Min column to that query, this will be transferred to the merged table, but it will calculate the value of each table separately without having to filter or group or anything else.

[Dorian_scr]

Exactly what I was looking for, thanks !

[lbendlin]

Please provide sample data in usable format and show the expected outcome.  This could be done with grouping or a list aggregator.