Forum Discussion
Helper ICreate a table from 0 to a 'dinamic value'
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
4 Replies
- Greg_Deckler
Community Champion
So, sample data would help but perhaps something along the lines of:
Table Methodology 1 = GENERATESERIES(0,MAXX(FILTER('Table'),[Methodology] = "Methodology 1"),[Points]),1)
There is a good bet that all of the assumptions I made are incorrect.
BTI_AfuentesThank 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,
- BTI_Afuentes
Hi,
Also, this is a link for a pbix file. Hope it helps
https://1drv.ms/u/s!AnDB-UKsg60w40wePfnmrXhzWiAE?e=aAFiZL
Thanks,
- BTI_Afuentes
Hi,
Is there any suggestion for creating the chart required?
Thanks,
Angel
