Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
DaurenA
Helper I
Helper I

Apply loss rates to distinct (unique) items. Calculate number of losses by animal age categories

Dear Friends,

 

I'm making a simulation model for a milk farm for 3 years. Need to to forecast gross quantity of animals by age groups and apply loss percentage. This is to see net number of the animals. 

 

The model is for 3 years. The questions is how to apply loss percentage to the distinct row of animals? May be mdel needs to select some of them based on predermined index or something else.

 

Also, I can send a model, since it can't be attached here.

 

Animal groups:

AgesAnimal Groups
0-31Молодняк, 0-3 мес.
4-62Телки, 4-6 мес.
7-123Телки, 7-12 мес.
13-184Телки, 13-18 мес.
19-265Нетели, 19-26 мес.
27-806Фуражные коровы, 27-80 мес.
81-2007Выбраковка, > 80 мес.

DaurenA_0-1704456540661.png

 

 

 

 Loss rates

Animal GroupAge1/31/20242/29/20243/31/2024
1Молодняк, 0-3 мес.0-30.7%0.7%0.7%
2Телки, 4-6 мес.4-60.5%0.5%0.5%
3Телки, 7-12 мес.7-120.3%0.3%0.3%
4Телки, 13-18 мес.13-180.3%0.3%0.3%
5Нетели, 19-26 мес.19-260.5%0.5%0.5%
6Фуражные коровы, 27-80 мес.27-803.0%3.0%3.0%
7Выбраковка, > 80 мес.81-2000.0%0.0%0.0%
2 REPLIES 2
v-xinruzhu-msft
Community Support
Community Support

Hi @DaurenA 

What is your logic for calculating the loss rates, based on the data you provided and the screenshots, I don't really know what the end result is that you want.

 

Best Regards!

Yolo Zhu

Hi @v-xinruzhu-msft 

 

Loss rates are in percentages and these are hard values based on judgement.

Using these percentages enables to calculate quantity of animal losses.

 

The issue is different context - loss rates are given for age groups, while main table (animal quantities) are unique items, one animal is one item.

 

I was able to apply and calculate losses on age gropus. Just want to make it better and apply losses to distinct animal.

That sounds quite complex, since the model should select exact row based on loss rate or quantity.

May be first step is to just identify quantity of losses, then randomply select from distinct rows such from quantity from 1st step. 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.