arnav yadav
New Member
- Joined
- Aug 4, 2022
- Messages
- 5
- Office Version
- 2021
- Platform
- Windows
Book1 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
3 | Ledger id | Ledger | sub ledger ID | Amount | ||
4 | 1001 | Admin Basic | A-001 | 10000 | ||
5 | 1002 | Admin Allow | A-001 | 10000 | ||
6 | 1003 | Dashain | A-001 | 5000 | ||
7 | 1001 | Admin Basic | A-002 | 12000 | ||
8 | 1002 | Admin Allow | A-002 | 12000 | ||
9 | 1003 | Dashain | A-002 | 6000 | ||
10 | 1004 | Prod Basic | P-001 | 14000 | ||
11 | 1005 | Prod Allow | P-001 | 14000 | ||
12 | 1003 | Dashain | P-001 | 7000 | ||
Sheet1 |
write a dax to filter the sub ledger if ledger id is 1001 and then sum the dashain for the filtered subledger