I Have 2 queries - 1 static and 1 that refreshes from a csv monthly - used for customer billing. The static table holds the customer information if they have a fixed amount of usage included in their plan:
| Customer | IncludedUsage |
| A | 100 |
| C | 75 |
The refreshing usage table has their daily usage
| Customer | Date | | Used |
| A | 1-Jan | | 32 |
| B | 1-Jan | | 11 |
| C | 1-Jan | | 18 |
| A | 2-Jan | | 67 |
| B | 2-Jan | | 5 |
| C | 2-Jan | | 13 |
| A | 3-Jan | | 40 |
| B | 3-Jan | | 2 |
| C | 3-Jan | | 12 |
On my report I need to have a table that shows their included usage - or actual usage if they exceeded their included usage. I know how I'd do it in SQL, but not sure how to do it in PowerBI - See customer A & C
January Usage
