New Business Development Calculation

[saurabh_das85]

Dear All,

PFA file ready for your reference. I have 3 tables - Customer Table (Customer Code, Associated Sales Person Code), Invoice Table (Invoice Details along with Customer Code for every invoice) and Calendar Table. I have created relatonships as well.

Now I want to calculate New Business Development (NBD) - Count of Customers and their Relative Business (NetInvQty field of Invoice Data Table).

Please make changes to the already created measure NBDCustCount and also please create two more measure - One for Quantity and One for YTD Quantity.

Note: Need this by Fiscal Year and not calendar year.

Download the attached file from here: Power BI Data Model