Forum Discussion
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
i am trzing to use this in DAX to create new measure.
i have no idea what that error means.
Hi Anonymous ,
I’d like to acknowledge the valuable input provided by the Greg_Deckler . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.
If you don't need a dynamic context, you can put it in a calculated table to display it.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- Greg_Deckler
Community Champion
Anonymous SUMMARIZE returns a table of values but measures, unfortunately, can only return scalars (single values). That is what the error means. So you need to do something like wrap your SUMMARIZE in a MAXX or SUMX or something like that so that it returns a single value and not a table of values.
thanks you Greg_Deckler for clarification.
my only option would be to transform via power query, am i right?
Hi Anonymous ,
I’d like to acknowledge the valuable input provided by the Greg_Deckler . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.
If you don't need a dynamic context, you can put it in a calculated table to display it.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
