Hi everyone,
I asking your help since I can't find a solution.
I am working on a Financial scorecard. I am using Excel 2013 with powerpvot. I want my users using the new feature timeline since it is really sharpe. However, when someone select 2014 January, I also want 2013 January in order to benchmark the data.
It was really easy with slicers since I was using years in column and I just put my days, weeks, months, in slicers.
However, I cannot find a solution with timeline.
I try calculated fields with =CALCULATE(sum([Revenue_without_tax]);SAMEPERIODLASTYEAR(MasterDate[Date])) or parallele periode with year -1 but it doesnt work.
I will be really pleased if someone can help me.
Thanks in advance and sorry fr my english since it is not my native language.,
Hugo
I asking your help since I can't find a solution.
I am working on a Financial scorecard. I am using Excel 2013 with powerpvot. I want my users using the new feature timeline since it is really sharpe. However, when someone select 2014 January, I also want 2013 January in order to benchmark the data.
It was really easy with slicers since I was using years in column and I just put my days, weeks, months, in slicers.
However, I cannot find a solution with timeline.
I try calculated fields with =CALCULATE(sum([Revenue_without_tax]);SAMEPERIODLASTYEAR(MasterDate[Date])) or parallele periode with year -1 but it doesnt work.
I will be really pleased if someone can help me.
Thanks in advance and sorry fr my english since it is not my native language.,
Hugo
