Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am calculation the average score but also have a check that the Survey_date and SendDate are the same. I know the first part of the set analysis but it is the Survey_date part which is causing the error. Both Survey_date and SendDate are both fields.
Avg({<FFMessage={'Score - Sales investigation'}, Survey_date={"=$(=SendDate)"}>}[Given Score])
avg({<FFMessage={'Score - Sales investigation'}>}if(Survey_date=SendDate,GivenScore))
or
avg({<FFMessage={'Score - Sales investigation'},Key_Column={"=Survey_date=SendDate"}>}GivenScore)
not so sure but
Avg({<FFMessage={'Score - Sales investigation'}, Survey_date = p(SendDate)>}[Given Score])