Matrix

[brinky]

I have created a matrix as per image below, any idea how to make dynamic ie will show till last week (ie wk23) or remove thos -100% from vol week column.

[Jihwan_Kim · Accepted solution]

Hi, @brinky 

Please try something like the below.

Vol week measure =
IF ( [CY] <> BLANK (), DIVIDE ( [CY] - [PY], [PY] ) )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM