Power BI DAX syntax for NPS calculation

€30-250 EUR

Closed

Posted

almost 7 years ago

€30-250 EUR

Paid on delivery

I need someone to create a correct formula syntax to calculate NPS score (Net Promoter Score). I have a column that contains grades given by customers from 0-10. There may be some row's where there is no grade (empty cells) and these row's should not be in the overall calculation. The overall calculation counts the amount of answers given and if there are row's with empty grade cells, these row's should not be counted at all. NPS Score Calculation: Example: If you received 100 responses to your survey: 10 responses were in the 0–6 range (Detractors) 20 responses were in the 7–8 range (Passives) 70 responses were in the 9–10 range (Promoters) (Number of Promoters — Number of Detractors) / (Number of Respondents) x 100 When you calculate the percentages for each group, you get 10%, 20%, and 70% respectively. To finish up, subtract 10% (Detractors) from 70% (Promoters), which equals 60%. Since an example Net Promoter Score is always shown as just an integer and not a percentage, your NPS is simply 60. (And yes, you can have a negative NPS, as your score can range from -100 to +100.) AND REMEMBER! Row's with empty cells in Grades column, should not be calculated to the amount of answers given!

Excel

Microsoft Expression

Project ID: 13807090

About the project

15 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

15 freelancers are bidding on average €129 EUR for this job

@dgled

Hi, I can build a spreadsheet with the NPS formulas + charts. just send me the responses from the questionnaire. regarding the Power BI, I lately started to work with it so I will try to produce the charts from it. About me I have an extensive experience in complicated financial projections, feasibility studies, and business plans. I am a specialist in financial reports, budget, costing reports, inventories, bill of materials construction models together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, formulas, Visual Basic Application including preparation of screen layout's, generator reports, dynamic dashboard, and charts. Throughout my career, I have created dozens of complicated financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a range of products and services. Areas of expertise: • Business valuation methodology & ratios (NPV, IRR, DCF, ROA, ROE, MCDA, CPI, SPI, EVM, KPI, Monte Carlo technique, WACC, S-Curve, DSCRratio, NPS, Multifactor Productivity). Reports based on KPI (Key Performance Indicators ) • Accounting, consolidating, forecasting, budgeting, and costing. • Implementation of information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP, ERP, Venture Capital system, CRM, etc.).

€250 EUR in 3 days

4.9

(93 reviews)

7.5

@yh2013

I have developed many projects that include excel macro and differents kind of equations, conditionals and diagrams I have the required expertise for developing your project. Check my developed projects and reviews of my portfolio.

€98 EUR in 3 days

4.8

(11 reviews)

3.7

@marvaland

I have good experience in power bi, already gone through Ssas Dax in power bi can give good solution .

€166 EUR in 5 days

5.0

(1 review)

1.4

@ArkadiuszDoda

I'm an Access pro, have several years of full-time MS Access/MS Excel based jobs and a US education. My databases and formulas are user-friendly and custom fit the expectations. I'd be happy to proceed with your project..

€30 EUR in 1 day

5.0

(1 review)

0.7

@gauravkhemka14

Major area of expertise includes C,C++ and python programming. Will deliver as promised.

€200 EUR in 5 days

0.0

(0 reviews)

0.0

@jeanfonsecav

A proposal has not yet been provided

€100 EUR in 2 days

0.0

(0 reviews)

0.0

@HammamJ

I have long experience in Power BI. I achieved many reports and I can share some of them with you if you want. I work as trainer power BI. I am new in freelancer but I confirm that your project will success. I hope to deal with you in this project. Power BI is very interesting and I could share some reports and dashboard that I designed.

€155 EUR in 3 days