help me....

[dansuk6]

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]

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

[dansuk6]

 

=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]

@dansuk6 
Dax does not support recursive calculations.

[dansuk6]

@tamerj1 

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

[tamerj1]

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

[amitchandak]

@dansuk6 ,

you need to try measure like

calculate(average(Table[Value]))

overall

calculate(average(Table[Value]), allselected() )

[dansuk6]

I'm sorry, but could you explain it more easily?

[amitchandak]

@dansuk6 .
Can you share sample data and sample output in table format? I will try share a pbix

[dansuk6]

@amitchandak 어떻게 공유할 수 있나요?