Forum Discussion
Distinct Net Value From Deliveries
Net Val = SUMX(FILTER(SUMMARIZE('Delivery Tracking',[Delivery],[Act. Gds Mvmnt Date],[Net Value]),FORMAT([Act. Gds Mvmnt Date],"yyyymm")=FORMAT(TODAY(),"yyyymm")),[Net Value])FORMAT([Act. Gds Mvmnt Date],"yyyymm")=FORMAT(TODAY(),"yyyymm")We are comparing the YearMonth of your data against the YearMonth of the "current" month, ie today's month.
I want to use the same measure you created but I want to limit the total to just the current month. My data table has two years worth of shipping data and currently the measure is giving me the total for all deliveries in my table. I do not want to use a filter on my visual for this.
Sample table below. Since the current month year is March 2024 the total should be $355,470.06 Ignoring any other months.
| Delivery | Plant | Act. Gds Mvmnt Date | Material | Net Value |
| 88028342 | D796 | 2/28/2024 | 21001STM | $44,497.76 |
| 88029678 | D796 | 2/28/2024 | 50024ACL | $16,874.60 |
| 88029678 | D796 | 2/28/2024 | 10020ACL | $16,874.60 |
| 88031087 | D796 | 2/29/2024 | 43128CLX | $374.48 |
| 88031087 | D796 | 2/29/2024 | 42432CLX | $374.48 |
| 88031087 | D796 | 2/29/2024 | 44240CLX | $374.48 |
| 88031086 | D796 | 2/29/2024 | 32636CLX | $381.11 |
| 88031086 | D796 | 2/29/2024 | 24205CLX | $381.11 |
| 88031085 | D796 | 2/29/2024 | 36020CLX | $483.40 |
| 88031077 | D796 | 2/29/2024 | 42432CLX | $278.62 |
| 88031077 | D796 | 2/29/2024 | 36020CLX | $278.62 |
| 88031077 | D796 | 2/29/2024 | 24205CLX | $278.62 |
| 88027366 | D796 | 3/1/2024 | 75030CSP | $33,398.76 |
| 88027366 | D796 | 3/1/2024 | 23002CSP | $33,398.76 |
| 88027366 | D796 | 3/1/2024 | 36006CLX | $33,398.76 |
| 88028943 | D796 | 3/1/2024 | 26342BIO | $131,246.24 |
| 88028943 | D796 | 3/1/2024 | 23733BIO | $131,246.24 |
| 88028943 | D796 | 3/1/2024 | 23762BIO | $131,246.24 |
| 88028943 | D796 | 3/1/2024 | 26344BIO | $131,246.24 |
| 88027157 | D796 | 3/1/2024 | 23758BIO | $57,174.68 |
| 88027157 | D796 | 3/1/2024 | 23756BIO | $57,174.68 |
| 88031155 | D796 | 3/4/2024 | 17465STM | $127,135.78 |
| 88031143 | D796 | 3/4/2024 | 18030STM | $6,514.60 |
Net Val = SUMX(FILTER(SUMMARIZE('Delivery Tracking',[Delivery],[Act. Gds Mvmnt Date],[Net Value]),FORMAT([Act. Gds Mvmnt Date],"yyyymm")=FORMAT(TODAY(),"yyyymm")),[Net Value])
this is working but can you explain how it is only selecting the current month year? I would like to get a better understanding.
Thanks again
FORMAT([Act. Gds Mvmnt Date],"yyyymm")=FORMAT(TODAY(),"yyyymm")We are comparing the YearMonth of your data against the YearMonth of the "current" month, ie today's month.
Ok one more question. I thought I could figure it out but just can't. Just as I asked for the net value I need a total count of deliveries shipped for current month. Data is below and it should show four deliveries shipped in March (current month).
Delivery Act. Gds Mvmnt Date 88029082 2/29/2024 88029067 2/29/2024 88029065 2/29/2024 88029051 2/29/2024 88029008 2/29/2024 88028983 2/29/2024 88028982 2/29/2024 88028980 2/29/2024 88028975 2/29/2024 88028955 2/29/2024 88027883 2/29/2024 88030339 2/29/2024 88024733 3/1/2024 88030531 3/4/2024 88030531 3/4/2024 88030531 3/4/2024 88031827 3/4/2024 88031827 3/4/2024 88031827 3/4/2024 88031827 3/4/2024 88031827 3/4/2024 88031827 3/4/2024 88031742 3/4/2024 88031742 3/4/2024 88031742 3/4/2024 88031742 3/4/2024 88031742 3/4/2024