Power BI DAX syntax for NPS calculation

€30-250 EUR

Cerrado

Publicado

hace alrededor de 7 años

€30-250 EUR

Pagado a la entrega

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 del proyecto: 13807090

Información sobre el proyecto

15 propuestas

Proyecto remoto

Activo hace 7 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

15 freelancers están ofertando un promedio de €129 EUR por este trabajo

@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 en 3 días

4,9

(93 comentarios)

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 en 3 días

4,8

(11 comentarios)

3,7

@marvaland

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

€166 EUR en 5 días

5,0

(1 comentario)

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 en 1 día

5,0

(1 comentario)

0,7

@gauravkhemka14

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

€200 EUR en 5 días

0,0

(0 comentarios)

0,0

@jeanfonsecav

A proposal has not yet been provided

€100 EUR en 2 días

0,0

(0 comentarios)

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 en 3 días