Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Date | Country | Goals Scored |
7/15/2018 | France | 4 |
7/15/2018 | Croatia | 2 |
7/14/2018 | Belgium | 2 |
7/14/2018 | England | 0 |
7/11/2018 | England | 1 |
7/11/2018 | Croatia | 2 |
7/10/2018 | France | 1 |
7/10/2018 | Belgium | 0 |
7/7/2018 | Sweden | 0 |
7/7/2018 | England | 2 |
7/7/2018 | Russia | 5 |
7/7/2018 | Croatia | 6 |
7/6/2018 | Uruguay | 0 |
7/6/2018 | France | 2 |
7/6/2018 | Brazil | 1 |
7/6/2018 | Belgium | 2 |
Using the data above my Table chart should look like this …
Country | Goals Scored |
Belgium | 4 |
Brazil | |
Croatia | 4 |
England | 3 |
France | 3 |
Russia | |
Sweden | |
Uruguay |
Can you assist?
Hi,
=IF ([Goals Scored]<=3,), Sum({$<NumDate= {'$(=(Max([NumDate])))'}>}[Goals Scored])
a comma to remove and two simple quotes to add
Hi,
=IF ([Goals Scored]<=3,), Sum({$<NumDate= {'$(=(Max([NumDate])))'}>}[Goals Scored])
a comma to remove and two simple quotes to add