Forum Discussion
Variance between measures
Sure so my dollar values, estimated revenue is measure that is the sum of the estimated revenue.
The column is one I created that takes the week the data falls into and combines it with the year so that we can compare each week of 2019's estimated revenue with each week of 2020's estimated revenue side by side. Being that I am only using 2 columns any measure that I create to give me a variance either is giving me a 0 or the number the number that is showing up for each of the weeks and sometimes it is positive and sometimes it is negative.
I created a prior year measure and linked to the calendar table and then created the variance using both the current prior year measures and that did not work either.
The raw data looks like this.
Hi Anonymous ,
Sorry, I don't this can be done in Matrix as the formula will calculate for each column.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.