Forum Discussion

SteveKingdon's avatar
SteveKingdon
Frequent Visitor
4 years ago

Calculating % Yield and Summing data.

Hi,   I am trying to do a simple yield calculation.  I have this data below, where I have a fields in this case: Bankey Field Little Gem with a total number of heads in of 176533. Bungalow Little...
Need Help
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi  SteveKingdon 

Thanks for reaching out to us.

I'd like to help you, but it seems that the data in the picture is not your original data, but the data after summary. Can you share your original data, provide the results you want, and mark the values on each row in the figure? thank you.

If you still don't know how to provide expected result, you can take a look at the last question I encountered, Porcentaje de variación respecto al dato anterior ... - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

SteveKingdon's avatar
SteveKingdon
Frequent Visitor
4 years ago

Please see some screen shots of the Query data. this is from a sql data base. 

 

I need to take the single count of the plant counts as a (not summed data as it is a single value showed mutilpe times against vaious time data and pay data as multpil days work in one field)

The SQL data base has various amounts harvetsed that need to be sunned for the specifc field and the a yeild calculation against the sinlge value of plant coutn for the field it is harvested.   

 

 

I hope this makes sense