I am trying to develop a graph like the attached. I want to get the accounts receivable days and the accounts payable days in each month and get the ratio between the 2 in power bi. See attached graph / visual.
The problem I am having is that I cannot get the average days per each month from the out of the box "accounts receivable" or "accounts payable" power bi file.
Is there a way to combine these 2 to develop the ratio? Is there a way to get the average days / month like the attached graph. Thank you.
This is not something that would be produced using the Excel Add-In.
We have something similar in our Power BI examples, but in a slightly different format.
We like the example, and will keep that in our hat for future reference.
Choose a location
Your session has expired. You are being logged out.