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,
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]
Hmm
can you please try to replace the above with the below?
(input[adition])/2, input[terms]),input[terms]
Nope...Kim