Forum Discussion
Solved
sales Calculation Customer wise
hi team
i have sales and return data
sales data
| Invno | date | Customer | item | qty | amount |
| 1001 | 15-01-2024 | John Doe | Smartphone | 1 | 700 |
| 1002 | 20-01-2024 | Jane Smith | Headphones | 2 | 150 |
| 1003 | 03-02-2024 | Sam Brown | Tablet | 1 | 350 |
| 1004 | 18-02-2024 | Lisa White | Smartphone Case | 3 | 30 |
| 1005 | 05-03-2024 | Bob Green | Charger | 2 | 40 |
| 1006 | 15-03-2024 | Alice Blue | Smartphone | 1 | 700 |
| 1007 | 07-04-2024 | Tom Black | Screen Protector | 5 | 25 |
| 1008 | 25-04-2024 | Mary Gold | Bluetooth Speaker | 1 | 100 |
| 1009 | 10-05-2024 | Peter Gray | Earbuds | 1 | 50 |
| 1010 | 20-05-2024 | Sara Pink | Smartwatch | 1 | 200 |
| 1011 | 02-06-2024 | George Blue | Smartphone | 2 | 1400 |
| 1012 | 12-06-2024 | Rachel Green | Tablet Cover | 4 | 80 |
| 1013 | 01-07-2024 | Steve Red | Power Bank | 3 | 90 |
| 1014 | 14-07-2024 | Olivia Purple | Wireless Mouse | 1 | 25 |
| 1015 | 03-08-2024 | Emma Yellow | USB Cable | 6 | 30 |
| 1016 | 15-08-2024 | Liam Brown | Laptop Stand | 1 | 60 |
| 1017 | 05-09-2024 | Noah White | Keyboard | 1 | 45 |
| 1018 | 18-09-2024 | Ava Blue | Monitor | 1 | 200 |
| 1019 | 02-10-2024 | Mia Black | Wireless Charger | 2 | 50 |
| 1020 | 20-10-2024 | Lucas Green | Gaming Console | 1 | 300 |
Sales Return
| RtnInvno | Return Date | Customer | Item | QtyRet | RefundAmt |
| R1001 | 25-01-2024 | Jane Smith | Headphones | 1 | 75 |
| R1002 | 10-03-2024 | Bob Green | Charger | 1 | 20 |
| R1003 | 15-05-2024 | Tom Black | Screen Protector | 3 | 15 |
| R1004 | 02-07-2024 | Sara Pink | Smartwatch | 1 | 200 |
| R1005 | 20-09-2024 | Ava Blue | Monitor | 1 | 200 |
customer table
| Customer |
| John Doe |
| Jane Smith |
| Sam Brown |
| Lisa White |
| Bob Green |
| Alice Blue |
| Tom Black |
| Mary Gold |
| Peter Gray |
| Sara Pink |
| George Blue |
| Rachel Green |
| Steve Red |
| Olivia Purple |
| Emma Yellow |
| Liam Brown |
| Noah White |
| Ava Blue |
| Mia Black |
| Lucas Green |
Both table related with Customer
the sales return is witch month occure then minus the return amount on that moth only
For your reference.
I make a calendar table, a mesure and a matrix below.
Calendar = CALENDARAUTO()
Measure = SUM('sales data'[amount])-SUM('Sales Return'[RefundAmt])
1 Reply
For your reference.
I make a calendar table, a mesure and a matrix below.
Calendar = CALENDARAUTO()
Measure = SUM('sales data'[amount])-SUM('Sales Return'[RefundAmt])