SQL-like GROUP BY in a LIST() or SELECT()?

Hi Community!

I was wondering if there’s a way to have a SQL-like GROUP BY statement inside a SELECT()?

Has anyone bumped into this challenge before? Maybe there’s clever workaround?

Here’s a screenshot that might help

You could use SUM(SELECT(TableName[QTY],[Vehicle Name]=[_THISROW].[Vehicle Name])). It will calculate all same vehicles in every row.

1 Like