Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to add new columns into the MATRIX table below;
This is the table i do have currently;
This is all working fine, now i want to add several new columns to this Matrix. Please see below what i am looking for; (For Example 2 columns below but there 7-10 columns i will add)
As you can see above "Number of Settlement" and "Number of Warning" are totally speparate Columns which has nothing to do with ROW and COLUMN headers (Left Side).
I am looking for count of certain cases based on different scenario.
Any suggestion would be appreciated
I tried with MATRIX and ACETRYS MATRIX LIGHT tables but its not working because whenever I add new columns it usually come inside column header which i dont want. New column must be seperate.
Thanks
Hello,
I have the same exact issue, and the sample was not much help. Has there been an update on this response?
-Jorge
@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!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I still have unresolved problems,
im trying with your file but idk why it cant visual , how to do that, pls guide me! thanks you.
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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |