Question

How do you apply multiple criteria to the same table ? Explain through an example

Answer 1

Hello there, I have a table in PowerPivot (let's just call it "table") and I need to create a calculated field that sums the value of field "currency" based on criteria within the table:

sum(table[currency])

Where

table[age] >9

and

table[age] < value of table[age] for the current row

and

table[product] = value of table[product] for the current row


I've found some posts with somewhat similar questions, but nothing that seems to work for this. I've tried Earlier(), SumX() with Filter()... I just keep getting errors, but I may not being using these correctly.

Answer 2

The cursor moves down one line in SQL view. Type FROM, followed by the name of the first of the tables you want in the query. Press ENTER. If you want to specify a criterion for a field from the first table, type WHERE, followed by the field name, a comparison operator (usually, an equals sign (=)), and the criterion.

Here is ur ans