Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to make a change to the following expression so that my chart includes all dates and ignores my date selections, can anybody help with this?
Sum({$<[Target Weight]={600},Class-={Nil}>}Aggr(Sum(Quantity)/[Calculated Cow Course],Product,ReferredTo,Year))
Thanks
May be try this:
Sum({$<[Target Weight]={600},Class-={Nil}, Date>}Aggr(Sum({<Date>}Quantity)/Only({<Date>}[Calculated Cow Course]),Product,ReferredTo,Year))
May be try this:
Sum({$<[Target Weight]={600},Class-={Nil}, Date>}Aggr(Sum({<Date>}Quantity)/Only({<Date>}[Calculated Cow Course]),Product,ReferredTo,Year))
sum({<Date=>})