Forum Discussion
Solved
Add JOB ID amount only its current date
Hello, you might have some answers to this. I have a table and I need a sum of the amount of my jobID if the jobID about is its latest date. Below is my table ID Name Job ID About Date ...
| Commission | RenewalDate |
| $238,966 | 4/1/2020 0:00 |
| $51,718 | 5/1/2020 0:00 |
| $87,436 | 6/1/2020 0:00 |
| $204,107 | 7/1/2020 0:00 |
| $244,060 | 8/1/2020 0:00 |
| $753,967 | 9/1/2020 0:00 |
| $47,273 | 10/1/2020 0:00 |
| $207,433 | 11/1/2020 0:00 |
| $23,588 | 12/1/2020 0:00 |
| $280 | 12/31/2020 0:00 |
| $4,785,567 | 1/1/2021 0:00 |
| $246,811 | 3/1/2021 0:00 |
| $224,783 | 4/1/2021 0:00 |
| $54,839 | 5/1/2021 0:00 |
| $213,057 | 6/1/2021 0:00 |
| $64,151 | 7/1/2021 0:00 |
| $231,259 | 8/1/2021 0:00 |
| $650,859 | 9/1/2021 0:00 |
| $45,247 | 10/1/2021 0:00 |
| $161,187 | 11/1/2021 0:00 |
| $19,009 | 12/1/2021 0:00 |
| $0 | 12/31/2021 0:00 |
| $5,328,343 | 1/1/2022 0:00 |
| $121,892 | 3/1/2022 0:00 |
| $180,999 | 4/1/2022 0:00 |
| $1 | 5/1/2022 0:00 |
| $0 | 6/1/2022 0:00 |
Hello, can you help me with this one? to capture the sum of the year 2022?
Comm =
CALCULATE (SUM(table[Commission] ),
FILTER (ALL(table[RenewalDate]),
YEAR(table[RenewalDate] ) =
YEAR ( MAX (table[RenewalDate]))))
i tried this but it won't show the correct total at the bottom. THinking to use SUMX
i tried this but it won't show the correct total at the bottom. THinking to use SUMX