Forum Discussion
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...
Thank you, that works
Just for future reference, here are some details for the suggested solution by AntonioHR
# calculated table
calc_table_updates = distinct(SELECTCOLUMNS(updates_engagement_bei_updates,"file_date", [file_date]))
# rank column of calculated table
rank = RANKX(calc_table_updates, [file_date],,,Skip)