Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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

 

 

2 Replies

  • Sean's avatar
    Sean
    Community Champion

    Anonymous Let me know if this helps...

    EDIT:

  • Anonymous's avatar
    Anonymous
    Not applicable

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