topic Re: help me.... in DAX Commands and Tips

help me....

dansuk6 — Mon, 11 Apr 2022 02:49:21 GMT

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

Re: help me....

amitchandak — Mon, 11 Apr 2022 04:11:24 GMT

dansuk6 ,

you need to try measure like

calculate(average(Table[Value]))

overall

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

Re: help me....

dansuk6 — Mon, 11 Apr 2022 04:29:17 GMT

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

Re: help me....

amitchandak — Mon, 11 Apr 2022 05:01:24 GMT

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

Re: help me....

dansuk6 — Mon, 11 Apr 2022 06:58:14 GMT

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

Re: help me....

tamerj1 — Mon, 11 Apr 2022 06:19:57 GMT

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

Re: help me....

dansuk6 — Mon, 11 Apr 2022 06:33:30 GMT

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

Re: help me....

tamerj1 — Mon, 11 Apr 2022 06:56:09 GMT

dansuk6
Dax does not support recursive calculations.

Re: help me....

dansuk6 — Mon, 11 Apr 2022 06:57:50 GMT

tamerj1

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

Re: help me....

tamerj1 — Mon, 11 Apr 2022 07:15:45 GMT

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