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

[Jon_S]

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?

[Jon_S]

Here’s a screenshot that might help

[Aleksi]

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