Forum Discussion

jaltoft's avatar
jaltoft
Resolver 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!!

v-sathmakuri's avatar
v-sathmakuri
Community Support
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!!

jaltoft's avatar
jaltoft
Resolver I
1 year ago

This is a really good solution v-sathmakuri and was really easy to follow, thanks.