Forum Discussion
Syntax Error Occurred during Parsing: Invalid Token Line 7 Offset 56
- 3 years ago
Hi, Anonymous
You can try the following formula.Duplicate = VAR _dCount = COUNTROWS ( FILTER ( 'DB 15092022_1', 'DB 15092022_1'[STO Number] = EARLIER ( 'DB 15092022_1'[STO Number] ) && 'DB 15092022_1'[Index] <= EARLIER ( 'DB 15092022_1'[Index] ) ) ) RETURN IF ( _dCount > 1, 1, 0 )If you have a large amount of data, you can try to calculate with measure.
Measure:Duplicate = VAR _dCount = COUNTROWS ( FILTER ( ALL ( 'DB 15092022_1' ), 'DB 15092022_1'[STO Number] = SELECTEDVALUE ( 'DB 15092022_1'[STO Number] ) && 'DB 15092022_1'[Index] <= SELECTEDVALUE ( 'DB 15092022_1'[Index] ) ) ) RETURN IF ( _dCount > 1, 1, 0 )Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , Problem with Single quote in table name, Try like
Duplicate =
--VAR dCount =
COUNTROWS (
FILTER (
'DB 15092022_1',
'DB 15092022_1'[STO Number] = EARLIER ( 'DB 15092022_1'[STO Number] )
&& 'DB 15092022_1'[Index] <= EARLIER ( 'DB 15092022_1'[Index] )
)
)
Hi Amit,
I have tried the formula as you suggested but it is taking more time to excecute please see the screenshot below
I am using excel as a source and it has 31k records of Data. Any suggestion please?