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
Donโt use [Comment] in the select()?
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |