Hi All,
I was wondering if anyone could offer some help/guidance with an issue I'm trying to solve.
I have a data set, which includes values in one column, and an "Iteration" designation in another. It starts with Baseline and then proceeds to Iteration 1, Iteration 2 and so on.
What I'm trying to do is show the % change for each Iteration in comparison to the Baseline. I used to be able to do this with a Pivot Table, but for the life of me I can't figure it out in Power View.
I was using dates, and was able to use "PreviousDay" to calculate the difference between each iteration, but still not the baseline. Can anyone help me out?
I was wondering if anyone could offer some help/guidance with an issue I'm trying to solve.
I have a data set, which includes values in one column, and an "Iteration" designation in another. It starts with Baseline and then proceeds to Iteration 1, Iteration 2 and so on.
What I'm trying to do is show the % change for each Iteration in comparison to the Baseline. I used to be able to do this with a Pivot Table, but for the life of me I can't figure it out in Power View.
I was using dates, and was able to use "PreviousDay" to calculate the difference between each iteration, but still not the baseline. Can anyone help me out?