cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TDMatthews Regular Visitor
Regular Visitor

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:

 

CustomerIncludedUsage
A100
C75

 

The refreshing usage table has their daily usage

 

CustomerDate Used
A1-Jan 32
B1-Jan 11
C1-Jan 18
A2-Jan 67
B2-Jan 5
C2-Jan 13
A3-Jan 40
B3-Jan 2
C3-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

CustomerUsage
A139
B18
C75

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Max between queries

@TDMatthews Let me know if this helps...

Max Between Queries.png

EDIT:

Max Between Queries2.png

2 REPLIES 2
Highlighted
Super User
Super User

Re: Max between queries

@TDMatthews Let me know if this helps...

Max Between Queries.png

EDIT:

Max Between Queries2.png

TDMatthews Regular Visitor
Regular Visitor

Re: Max between queries

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