Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a list of methodologies and indicators for each methodology. Then I created a summarized table where I identified total MAX possible points for each Metodology.
Now I need to create a table (or maybe a column) with values from 0 to MAX points for each methodology.
New table (from 0 to 'total max points) will be used for a line chart)
How can that be achieved?
Thanks,
Angel
Hi,
Is there any suggestion for creating the chart required?
Thanks,
Angel
Hi,
Also, this is a link for a pbix file. Hope it helps
https://1drv.ms/u/s!AnDB-UKsg60w40wePfnmrXhzWiAE?e=aAFiZL
Thanks,
Thank you very much for your help Greg.
I'm attaching an example of the tables. I tried with your suggestion but is this for generate a table for each methodology?
Projects table:
Project ID | Methodology ID |
Project 1 | Methodology 1 |
Project 2 | Methodology 2 |
Methodologies table (summarized table)
Methodology ID | Max points |
Methodology 1 | 100 |
Methodology 2 | 150 |
Methodology 3 | 90 |
Indicators table:
Indicator ID | Points | Methodology ID |
Indicator 1 | 20 | Methodology 1 |
Indicator 2 | 30 | Methodology 1 |
Indicator 3 | 50 | Methodology 1 |
Indicator 4 | 10 | Methodology 2 |
Indicator 5 | 20 | Methodology 2 |
Indicator 6 | 50 | Methodology 2 |
Indicator 7 | 70 | Methodology 2 |
Indicator 8 | 20 | Methodology 3 |
Indicator 9 | 20 | Methodology 3 |
Indicator 10 | 20 | Methodology 3 |
Indicator 11 | 30 | Methodology 3 |
New table:
(column 2 is a calculated by a formula: =1/(1+EXP(-(('Methodology max ponts'/2)-Column1')*LN(2)/4))
Column1 | Column2 |
0 | 99.98% |
1 | 99.98% |
2 | 99.98% |
3 | 99.97% |
4 | 99.97% |
5 | 99.96% |
… | |
100 | 0.02% |
I tried to attach an excel file but didn't find the option.
Thanks again,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |