This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
No, it's not.If the same record does not already exist in the additional
condition SELECT function, it will be
processed---------------------Condition:COUNT(SELECT(DESTINATION
TABLE[Date],AND([Date]=[_THISROW].[Date],[Name]=[_THISROW].[Name])))=0
sorry. I misunderstood.How about a combination of the following data
structure and a bot that adds events to the Future Tasks table?1.
DESTINATION TABLEFuture Task:(virtual column)COUNT(SELECT(Future
Tasks[Name],AND([Date]=[_THISROW].[Date],[Name]=[_...
Circular references to dynamic virtual columns are not recommended as
they degrade performance as the number of data items increases.Try
changing the Contribution ratio to either a fixed value or a static
reference to another table.Another possibilit...