Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
saurabh_das85
Regular Visitor

New Business Development Calculation

‎06-22-2023 10:27 PM

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 

Labels:
Message 1 of 1
182 Views
0
0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All