Forum Discussion

Regular Visitor

5 years ago

Solved

Sum Monthly Divides by Detail

Hello everyone, I have the following example data Month Day Term Amount Sep 7 100 Sep 30 120 Sep 45 104 Sep 7 99 Sep 30 93 Sep 45 104 Oct 7 94 Oct 30 ...

Need Help

amitchandak
5 years ago
javr , Try daily ratio like

New column

divide([Term Amount],sumx(filter(Table, [month]= earlier([month])),[Term Amount]))

new Measure
% = divide(sum(Data[Term Amount]),sumx(filter(allselected(Data), Data[month]= max(Data[month])),Data[Term Amount]))

Min Days Term = MIN(Data[Day Term])

Avg Day Term = sumx(summarize(Data,Data[Month], Data[Day Term],"_1", [Min Days Term] * [%]),[_1])