Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone, hope you all are doing fine!
I have just started to work on this awesome tool, and I have found my first problem hahaha.
I have a table in wich I am storing a PC name and a yield percentaje.
Table looks like this:
What I am trying to achieve here, is to be able to multiply the values on the Yield column: (0.9964 * 0.9930 * 0.9920 * 0.9872 * 0.9844)
Once I have that information, I need to show that in a donut chart.
I guess it has to be done with some sort of while or if loop, but I am not sure on how to do it.
Any help is very much appreciated.
Thanks!
Solved! Go to Solution.
Hi @FedePrado ,
please check the PRODUCTX-function for this.
If you need help implementing this, please share more details, i.e. if you want a cumulative approach, what the order is, if "Yield" is a measure or a column...
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @FedePrado ,
please check the PRODUCTX-function for this.
If you need help implementing this, please share more details, i.e. if you want a cumulative approach, what the order is, if "Yield" is a measure or a column...
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @ImkeF !!!
Thanks for your reply, I will look on that function right away!
I am working on a report that based on some filters shows information about yiels and yars of ome production lines, the first graphic tht is shown is a Yield graphic, lets call it "genelra yield" for all the stations in a selected production line. This is the graphic that I am trying to create here.
I am already showing the yields per station as shown in the screenshot I shared, the Yield information shown on the screenshot is a measure that is calculated using two columns of a table that is called Yield also.
In short, I just need to find a wey to multiply the values of the Yield measure one by one, to get the value for the "general yield" graphic.