Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
That is exactly what I am trying to do! Thank you very much!!
@Anonymous Let me know if this helps...
EDIT:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |