Example weighted average receivables demo. Weighted average debt age, weighted average due days and weighted average overdue days. Interactive demo shows how you can slice by customer to see who you should be focusing on to drive down your debtor days. What does this tell you?
BIPurchaseOrderLines - Sage 50 Accounts Purchase Order Lines table
A description of the BIPurchaseOrderLines table details in the Suntico Sage 50 Accounts OData feed for Power BI. This table contains all of your Sage 50 Accounts Purchase Order Lines from your Sage 50 POP module. Why not try it now?
Details about the BICustomers table in the Suntico BI data feed for Power BI. Use this to add customer reference information into your analysis such as currency, country, average time to pay, credit limit, balance, due days etc.. Why not try it now?
A summary of my favourite Power BI DAX functions. SUMX, CALCULATE and FILTER. Why I always use SUMX and not SUM. The power of CALCULATE. The super combination of CALCULATE & SUMX together. The importance of filters and FILTER. Example given in DAX code.