Dear pros! Any tip on how to quickly solve a...

expressions
(Jerry Lan) #1

Dear pros!

Any tip on how to quickly solve a circular expression? I wanted to have a site activity identified here by [Comment] concatenated by the number of days passed since reported. So I created this virtual column:

=[Comment]&" D"&[_ThisRow].[Date]-min(Select(Jetty 3 Journal[Date],[Comment]=[_ThisRow].[Comment]))

But I got this circular error:

Unable to fetch app definition: Error:Expression appears to be part of a cycle: SELECT(Jetty 3 Journal[Comment & DateTime],AND(([SECTION] = [Comment & DateTime].[SECTION]), ([DateTime] = MAX(SELECT(Jetty 3 Journal[DateTime],([SECTION] = [Comment & DateTime].[SECTION]))))))/nExpression appears to be part of a cycle: SELECT(Jetty 3 Journal[Comment & DateTime],AND(([SECTION] = [Comment & DateTime].[SECTION]), ([DateTime] = MAX(SELECT(Jetty 3 Journal[DateTime],([SECTION] = [Comment & DateTime].[SECTION]))))))/n

(Steven Coile) #2

Don’t use [Comment] in the select()?