Forum Discussion
Add Average Function into Summarize
Hi Experts I want the average of a particular column in the following DAX Summary = filter ( Summarize (Input[Year],Input'[M Column],Average(Input[Addtion]/2), Input[Terms]), Input[Terms] = "BTM...
Hmm
can you please try to replace the above with the below?
(input[adition])/2, input[terms]),input[terms]
Hi Kim error from this point onwards (Input[Addtion]/2), Input[Terms]), Input[Terms]
Jihwan_Kim
Super User
Super UserHmm
can you please try to replace the above with the below?
(input[adition])/2, input[terms]),input[terms]
Nope...Kim
- Jihwan_Kim
please share the sample pbix file, if possible.
That will be very much helpful for me to come up with a more accurate measure.
"RT",(Average(input[Additon])/2), works but error ,Input[Terms]),Input[Terms]="BTMT")