Forum Discussion
Resolver IDynamic 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!!
Community SupportHi 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!!
jaltoftThis is a really good solution v-sathmakuri and was really easy to follow, thanks.
- jaltoft
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 - v-sathmakuri
Hi jaltoft ,
As per your sample data implemented the solution. Please find the attachment for the solution.
Thank you!!