Max between queries

[Anonymous]

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]

That is exactly what I am trying to do! Thank you very much!!

[Sean · Accepted solution]

@Anonymous Let me know if this helps...

EDIT: