Power BI DAX syntax for NPS calculation

€30-250 EUR

Ditutup

Disiarkan

sekitar 7 tahun yang lalu

€30-250 EUR

Dibayar semasa penghantaran

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 Projek: 13807090

Tentang projek

15 cadangan

Projek jarak jauh

Aktif 7 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

15 pekerja bebas membida secara purata €129 EUR untuk pekerjaan ini

@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 dalam 3 hari

4.9

(93 ulasan)

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 dalam 3 hari

4.8

(11 ulasan)

3.7

@marvaland

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

€166 EUR dalam 5 hari

5.0

(1 ulasan)

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 dalam 1 hari

5.0

(1 ulasan)

0.7

@gauravkhemka14

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

€200 EUR dalam 5 hari

0.0

(0 ulasan)

0.0

@jeanfonsecav

A proposal has not yet been provided

€100 EUR dalam 2 hari

0.0

(0 ulasan)

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 dalam 3 hari