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.
User | Count |
---|---|
42 | |
34 | |
26 | |
23 | |
15 |