Calculate points if less than or equal to 3

brucemeyers — Wed, 12 Sep 2018 16:01:59 GMT

If ‘Goals Scored’ is less than or equal to 3 I want the expression below to calculate otherwise do nothing

=Sum({$<NumDate= {$(=(Max([NumDate])))}>}[Goals Scored])

Here is my expression that the expression editor says OK for but when I click Apply, it does not work

=IF ([Goals Scored]<=3,), Sum({$<NumDate= {$(=(Max([NumDate])))}>}[Goals Scored])

Here is my data

Using the data above my Table chart should look like this …

Can you assist?

Re: Calculate points if less than or equal to 3

YoussefBelloum — Wed, 12 Sep 2018 16:07:21 GMT

Hi,

=IF ([Goals Scored]<=3,), Sum({$<NumDate= {'$(=(Max([NumDate])))'}>}[Goals Scored])

a comma to remove and two simple quotes to add