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.
Hello,
I am very new to PBI and this is my very first post in here.
I have a problem to calculate progress. Let me explain the way best I can. This involves plant nurseries, at the start of the year they are given targets. (number of plants to be produced.) Lets say plants can be two types, Pepper and Cinnamon.
So time to time they produce some quantity of plants and issue produced plants (to farmers).
so progress a plant type = (total produced quantity) / target for that plant time of that nursery
I want to create a measure to do so. please help.
I have attached some images if that helps.
Thank You.
Could you share your pbix file?
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
At the time I didn't know I can share pbx files here. Thanks for your reply.
I figured out how to do it now.
Cheers ...!!!
Hi @StatInsight,
Glad to hear that you have worked it out. Would you please share the solution so that it can benefit more community members?
Thanks,
Yuliana Gu
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |