Forum Discussion
Problem with Counting rows
Hello foks, I have a data like call_no part_no date_lt country 1234567 aa123 5/15/2023 le 1234567 bb456 5/21/2023 le 1234567 cc789 5/26/2023 le 456789 qq987 4/12/2024 ...
What's happend with call_no = 1234567 since it is not in the table now?
Next, when I try to create RANK based on your instruction I got an error: EARLIER/EARLIEST refers to an earlier row context which doesn't exist.
1234567 is in year 2023 and my screenshot was of the data for 2024.
Here is the screenshot for both the years.
It is RANKX and not RANK. Create a calculated column and not a measure.