Forum Discussion
Solved
Reference a row in another column
Hello, I hve two columns in the same table, onde of them is the index one, I want to reference the id number of that index, for example: ID INDEX 8027890 ...
Hi, pagliaci
According to your description, I can clearly understand your requirement, you can try to create a calculated column like this:
Column = var _lastID=CALCULATE(MAX('Table'[ID]),FILTER(ALL('Table'),[INDEX]=EARLIER('Table'[INDEX])-1)) return IF([ID]=_lastID,"SAME ID","DIFFERENT ID")And you can get what you want, like this:
You can download my test pbix file below
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jos_Woolley
Solution Sage
Solution SageHi,
Calculated Column:
Duplicate? =
VAR MyID = 'Table'[ID]
VAR MyIDCount =
CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[ID] = MyID ) )
RETURN
IF ( MyIDCount > 1, "Duplicate" )
Regards