Hi,
Is there a way to multiply two columns inside a Select? Something like SELECT(tableName[Col1]*[Col2], CONDITION) ?
That will be really helpfull
Thanks!
Nope.
And since it is not possible, you could create a Virtual Column with this App Formula and then use that in your SELECT(…) expression:
=[Col1]*[Col2]
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |