Forum Discussion
Dynamic index (Value) based on slicer
Hi jaltoft ,
Thank you for reaching out to Microsoft Fabric Community.
I have used sample data that aligns with your scenario and calculated the base value accordingly. Please find the attached solution. Let us know if you need any further assistance.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
Hello v-sathmakuri can you help please this is similar to my above as I have not started a new request. The above answer was perfect however I have an addition to my Power BI I need to create a weighted index between 3 index, I have attached a spreadsheet to show you how it is calculated with test data on Excel. I need to be able to re-base the weighted index like has already been done in the example above. (This is the format in Excel my database is a list going down like you set it up).
In the Excel rows 1 and 2 E-G I have the weightings -
This is an example of the formula for the index I need to make a weighting for with the three values with the ability for it to be also rebased as you have done before - =($E$2*100*C16/$C$4)+($F$2*100*E16/$E$4)+($G$2*100*G16/$G$4)
So within this formula E2 for example is the Weighting then it is the month C16 / C4 which is what I need a selected base for. Can you help?
| 1234 | 5678 | 9578 |
| 0.217927 | 0.156415 | 0.625658 |
| DateColumn | Series Number | Index | Series Number | Index | Series Number | Index | Pavement |
| 01/01/2022 | 1234 | 130.9 | 5678 | 121.8 | 9578 | 110.8 | |
| 01/02/2022 | 1234 | 131.5 | 5678 | 120.8 | 9578 | 110.1 | |
| 01/03/2022 | 1234 | 131.3 | 5678 | 120 | 9578 | 109.4 | |
| 01/04/2022 | 1234 | 130.4 | 5678 | 117.1 | 9578 | 109.1 | |
| 01/05/2022 | 1234 | 128.9 | 5678 | 117.1 | 9578 | 109 |
Hi jaltoft ,
As per your sample data implemented the solution. Please find the attachment for the solution.
Thank you!!