This content has been marked as final.
Show 3 replies

1. Re: Using a calculated field as a reference for YoY calculations?
Ivan Young Mar 7, 2017 12:39 PM (in response to Lily Huang)1 of 1 people found this helpfulHi Lily,
Are you looking to generate something like below? If so you need to create measures for X and Y like IF [Property] = 'X' then [Value] END, then use the sum of those measures for the percentage.
Regards,
Ivan

2. Re: Using a calculated field as a reference for YoY calculations?
Lily Huang Mar 7, 2017 1:03 PM (in response to Ivan Young)Hi Ivan,
This is exactly what I was trying to do. Should have approached it this way to begin with. Thank you so much!
Lily

3. Re: Using a calculated field as a reference for YoY calculations?
Ivan Young Mar 7, 2017 1:15 PM (in response to Lily Huang)Hi Lily,
My pleasure! Glad it worked. I've found this is the easiest way to compare values in the same column.
Ivan