The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

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.