PBIForumAnimalDays.xlsx

	A	B	C	D	E	F	G	H	I	O
1	Row Labels	Begin	Invty Change	End Invty	Animal Days	Animal Days Cumulative	Feed Fed Lbs	Feed Fed Lbs Cumulative	Cumulative Animal Days

2	LF56	0	0	0	0	0	399,356	399,356	12,371
3	LF56H	0	0	0	0	0	399,356	399,356	12,371	IF ( HASONEVALUE( <columnName> ), VALUES( <columnName> ), <alternateResult> )
4	1/1/2024		136	136	136	136	3,634	3,634
5	1/2/2024	136		136	136	136	3,692	7,326	136
6	1/3/2024	136		136	136	136	3,750	11,076	272
7	1/4/2024	136		136	136	136	3,743	14,819	408
8	1/5/2024	136	-1	135	135	135	3,799	18,618	544
9	1/6/2024	135		135	135	135	3,858	22,476	679
15	1/12/2024	135	-3	132	132	132	3,799	45,102	1,489
16	1/13/2024	132		132	132	132	3,799	48,901	1,621
130	5/6/2024	30		30	30	30	1,233	399,356	12,341
131	5/7/2024	30	-30	0	0	0		399,356	12,371
132	Grand Total	0	0	0	0	0	399,356	399,356	12,371
133
134
135
136
137									=Var ReportValue = sumx(values(Consolidated[Group ID]),calculate([Feed Fed Lbs],FILTER(
138									ALL( 'Calendar'),
139									'Calendar'[Dates] <= max( 'Calendar'[Dates] ))))
140
141
142									return ReportValue
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218