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]
Jihwan_Kim
Super User
Super UserHi,
please try the below.
Summary = filter ( Summarize (Input[Year],Input'[M Column], "@newcolumn", Average(Input[Addtion]/2), Input[Terms]), Input[Terms] = "BTMT")
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
Hi Kim error from this point onwards (Input[Addtion]/2), Input[Terms]), Input[Terms]
- Jihwan_Kim
Hmm
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.