Forum Discussion
Anonymous
10 years agoNot applicable
Max between queries
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
| Customer | Usage |
| A | 139 |
| B | 18 |
| C | 75 |
Anonymous Let me know if this helps...
EDIT:
2 Replies
- SeanCommunity Champion
Anonymous Let me know if this helps...
EDIT:
- AnonymousNot applicable
That is exactly what I am trying to do! Thank you very much!!