Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I tried inforiver

 

Note:-  years in sample given only had two but we have multiple years through 2019-2023(2023 only forecast) and it increases as years pass.

Final comparison is only for current vs next year (i.e., actual vs forecast). All remaining years regular side by side values.

Something below I did finally I ended up hardcoding 2022 vs 2023 values.

devarajns's avatar
devarajns
Regular Visitor
3 years ago

It's absoultely possible, in formula you can mentions "index" based formula of column position

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Any sample pbix. ?

    • devarajns's avatar
      devarajns
      Regular Visitor
      3 years ago

      You can see the "index" based formula there