Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculated column with column = measure yields different result than column = hardcoded value

Hello,   I would like to add calculated columns indicating if a row contains the latest or second latest value in the file_date column. This works well with the latest value, but does not with the...
Need Help
AntonioHR's avatar
AntonioHR
Icon for Helper I rankHelper I
4 years ago

Hello, 

I'm not sure if I have understand it correctly, but you could try creating a table (DISTINCT dates) and using RANKX on it. 1 and 2 will be the lastest and second lastest, so after you link the two tables using date you can add the calculated column.