Power BI DAX syntax for NPS calculation

€30-250 EUR

Închis

Data postării:

circa 7 ani în urmă

€30-250 EUR

Plata la predare

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

ID-ul proiectului: 13807090

Despre proiect

15 propuneri

Proiect la distanță

Activ: 7 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

15 freelanceri plasează o ofertă medie de €129 EUR pentru proiect

@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 în 3 zile

4,9

(93 recenzii)

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 în 3 zile

4,8

(11 recenzii)

3,7

@marvaland

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

€166 EUR în 5 zile

5,0

(1 recenzie)

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 în 1 zi

5,0

(1 recenzie)

0,7

@gauravkhemka14

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

€200 EUR în 5 zile

0,0

(0 recenzii)

0,0

@jeanfonsecav

A proposal has not yet been provided

€100 EUR în 2 zile

0,0

(0 recenzii)

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 în 3 zile