Forum Discussion
Add new columns separately yo Matrix Table
damit23183 there is a workaround for this, see attached and you will get an idea, look at the matrix with the blue background, you need to apply the similar logic.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Hi,
Yes I went through it which i already have that is total of each row but, I would like to add new columns which has nothing to do with current and lastyear values. If you take your example then ALL Total / Grand Total column is sum of rows and columns value.
If you take your example then I would like to add two new columns into the existing Matrix;
1) No of products where date is not Null = NOPWON
2) No of Products where date is null = NOPWN
This is just an example;
Your example should look like below; this is an example from EXCEL but this is what i am looking for.
Thanks
damit23183 idea is in the solution I pasted, you have to tweak it as per your needs, you can control whatever you want.
Hi,
Thanks for quick turn around.
My apologies, didn't look at Measure that you have created with variable.
Thought to be direct solution but i will look into that MEASURE and see how it work.
Thanks a lot for your suggestion.
Thanks
damit23183 as I mentioned, it is not out of the box, you have to create workaround as shown in shared in pbix. good luck.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!