Forum Discussion
Matrix or table with side-by-side time period comparison
Hi All, Here is my input table contains 2022 and 2023 actaul(2022) vs forecast.(2023). November and december are forecast months in (2022) and 2023 is completely forecast. AGC SPNAME Y...
Did this with 0 DAX, using Inforiver
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.
It's absoultely possible, in formula you can mentions "index" based formula of column position
Any sample pbix. ?
Can you also please post pbix? if it is not sensitive and confidential info