Solved: Re: Matrix

brinky · ‎06-07-2021

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 · ‎06-07-2021

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

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

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

Jihwan_Kim · ‎06-07-2021

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

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

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Matrix

Helpful resources

Power BI Dataviz World Championships

Power BI Monthly Update - December 2025

FabCon Atlanta 2026

How to Get Your Question Answered Quickly

FabCon is coming to Atlanta