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...
One more question:
rankx result is wrong - even though it's not a tie
Threads on rankx with datetime columns like Solved: Rank based on date for each individual user - Microsoft Power BI Community unfortunatelly did not work
AntonioHR
Helper I
Helper Immm try RANKX just with table and date, It works for me.
rank = RANKX(calc_table_updates, file_date)
Hmm thats how I did it - Re: Calculated column with column = measure yields... - Microsoft Power BI Community
rank = RANKX(calc_table_updates, [file_date],,,Skip)