Forum Discussion
Solved
Weighted average based only on 3 latest date points
Hi all, could you please help me with the case below? I want "WEIGHTED PD0" to be an average value of "%PD 0 dpd" weighted by "*Balance bucket 0" (screen 1). The thing is that the weighted avera...
In your scenario, since you need a cumulative calculation for your "weighted avg", you must have an index column in your source table. Then you can write a measure like below:
Measure = CALCULATE ( SUMX ( Table1, [%pd 0 dpd*] * [Balance Bucket*] ) / SUM ( Table1[Balance Bucket] ), FILTER ( ALL ( Table1 ), Table1[Index] <= MAX ( Table1[Index] ) ) )Regards,
v-sihou-msft
Microsoft Employee
Microsoft Employee
In your scenario, since you need a cumulative calculation for your "weighted avg", you must have an index column in your source table. Then you can write a measure like below:
Measure =
CALCULATE (
SUMX ( Table1, [%pd 0 dpd*] * [Balance Bucket*] )
/ SUM ( Table1[Balance Bucket] ),
FILTER ( ALL ( Table1 ), Table1[Index] <= MAX ( Table1[Index] ) )
)
Regards,