Forum Discussion

dansuk6's avatar
dansuk6
Frequent Visitor
4 years ago

help me....

You want to calculate the arithmetic mean of the data by the amount going in and the amount overall, as shown in the figure above. I don't know what to do Help me
tamerj1's avatar
tamerj1
Community Champion
4 years ago

HI dansuk6 
Would you please explain further this type of calculation. What are the excel formulas invloved?

dansuk6's avatar
dansuk6
Frequent Visitor
4 years ago

 

 

=IFERROR(IFS(AND($AA6="",$AB6=""),AR3,AR3>0,(AR3*$AZ3+BC2*$BB2)/$BB3,AR3<=0,BC2),"")

 

 

Using these formulas, calculate the arithmetic mean when in and get the previous arithmetic mean data when out.

 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    dansuk6 
    Dax does not support recursive calculations.

    • dansuk6's avatar
      dansuk6
      Frequent Visitor
      4 years ago

      tamerj1 

      I know that. I want to make this into a power bi

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        dansuk6 
        You could try using Power Query (M-Language). amitchandak might advise on that.