Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |