Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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.
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.
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |