Forum Discussion

jaltoft's avatar
jaltoft
Icon for Resolver I rankResolver I
1 year ago
Solved

Dynamic index (Value) based on slicer

I am trying to recreate what I have in Excel within Power BI, shown in the table is a spreadsheet. In column G (Oct-21 this is a list which you can lick the dates from column A, column I (2010 base i...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    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!!

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

Hi jaltoft  For this create a slicer using the Date column and a measure to calculate the base value (BaseValue) from the selected date. Add another measure (RebasedIndex) to compute the index relative to the base using the formula: Index * 100 / BaseValue. Include these in a table visual alongside Date and Series_Name.

jaltoft's avatar
jaltoft
Icon for Resolver I rankResolver I
1 year ago

How would I work out the base value (BaseValue) from the selected date?