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:
The refreshing usage table has their daily usage
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
Solved! Go to Solution.