Hey I have an issue with a project. We have platform for monitoring customers which they consume different licenses. For billing we need to pull out that data every month. That consist of pulling data from 7 different API's pr customer. The job is to consolidate all data 7 Calls x 300ish customers into one readable report to do billing. Columns: Customer, Month, Licenses Consumed. Some months a customer might not have consumed licenses from one or more of the API's which results in NULL and a different format of the tabel, which makes the consolidation troublesome as this is not consistant.
Any ideas on how to approach this problem? I want to make a template for each call, making it easy to add all the different calls into power bi for all customers.
Is it possible to do an IF in the advnaced editor with two different outcomes? E.g IF no data: (make "this let&in" table with 0 and the current month, instead of just NULL) ELSE make: "this let&in".
Or even better: is there a way to add all the calls into one query? Or 7 different queries with query 1 having all the api calls for license 1 and query 2 with all the calls for license 2 and so on...
I've read up on the community on this and there are some similar issues but it does'nt work especcially due to no data on some of the calls.
I'm really strugling here and i'm new to power BI. Let me know if there's any information i might add! Any help is much appriciated!
