Forum Discussion

allmana's avatar
allmana
Regular Visitor
10 years ago
Solved

WEIGHTED AVG

Hi,  I am having difficulty created a weighted avg measure (balance*int rate) and tried creating a helper column to no avail. I am new to PBI and would appreciate assistance.
  • leonardmurphy's avatar
    leonardmurphy
    10 years ago

    SUM([Net_Active_Balance])

     

    not SUM('Analytics_SourceDat',[Net_Active_Balance])

     

    perhaps?

rkalantri's avatar
rkalantri
Frequent Visitor
9 years ago

It doesnt work for me

 

Measure = SUM(SODUMP100915[NETAMT]-SUM(SODUMP100915[FREIGHTBOOKED]/SUM(SODUMP100915[NET_QUINTAL])))

The SUM function only accepts a column reference as an argument.

 

even tried creating a new column

Column = sum(SODUMP100915[NETAMT]-sum(SODUMP100915[FREIGHTBOOKED]/sum(SODUMP100915[NET_QUINTAL])))

The SUM function only accepts a column reference as an argument.

 

Please give me a solution so i can create  weighted average.