Forum Discussion

PQ-Noob675137's avatar
PQ-Noob675137
Frequent Visitor
2 years ago
Solved

Grouped by Max Source.Name, table.max returns error

Hi Im struggling using the table.max as its returning; Expression.Error: The specified sort criteria is invalid. Details: let Source = Folder.Files("XX"), #"Filtered Hidden Files1" = Table.Selec...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    each Table.Max([Detail],"Source.Name")

PQ-Noob675137's avatar
PQ-Noob675137
Frequent Visitor
2 years ago

Hi thanks for the reply. It worked!

 

I am running into a somewhat different problem. I have tried this with a small batch of data. Ive just tried the same steps above but with 5 CSV files (+- 1GB) and it seems Power Query is not responding anymore.

Is there a more efficient way of doing this?
The objective is to retrieve the max value of Source.Name for each ID and their row information. 

Thanks in advance

 

dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi PQ-Noob675137, you should mark Ibendlin's post as a solution and create new topic.