Forum Discussion
Issue with New Colimn query
I am trying to enter a filter query to select a part of a table I have. The query however is returning the error - The expression refers to multiple columns. Multiple columns cannot be converted to a...
Hi Anonymous,
Calculate function not able to return table, you need to apply aggregate on your results to keep only return one column(calculated column) or one value(measure)
What aggregate method you want to apply on your formula if multiple records suitable for your conditions?
In addition, what type of calculated fields did you want? if you want its result can be dynamic filter by filter/slicer, please use measure formula.
Regards,
Xiaoxin Sheng