Forum Discussion
Solved
Error Sort by another column | can't find it
Hello, I can't find the problem. I get an error This is my pibx file . I have 1 querie / sheet called RGS schema original with the error. Splitted this table in four separate table...
Create a measure to COUNT the sortering value. Put it in a table with Omschrijving.
Order it by the measure and you'll find the duplicates.
HotChilli
Community Champion
Community ChampionCreate a measure to COUNT the sortering value. Put it in a table with Omschrijving.
Order it by the measure and you'll find the duplicates.
Thnx,
used calculated column. Find some duplicates 😞
DuplicateFlag =
IF (
COUNTROWS ( FILTER ( _originalRGS; _originalRGS[Omschrijving] = EARLIER ( _originalRGS[Omschrijving] ) ) )
> 1;
1;
BLANK ()
)