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] = "BTMT")
Adding the Average(Input[Addtion]/2) gives and error.
Hmm
can you please try to replace the above with the below?
(input[adition])/2, input[terms]),input[terms]
6 Replies
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.
Hmm
can you please try to replace the above with the below?
(input[adition])/2, input[terms]),input[terms]