Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

help needed

  I need to calculate the sum of VCI_RECEIVED_Head on group by feedyard ,pen_id and lot_id .can you help me here . even if the rationid is different but for example in below row2 and row3 are unique...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

I made one sample based on your sample data. We can create a calculated table.

 

Table = SUMMARIZE(Table1,Table1[FEEDYARD],Table1[lot_id],Table1[pen_id],Table1[VCI_RECEIVED_Head])

 

Also please find the pbix as attached.

 

Regards,

Frank