HI Guys, I want to have a column that pull the date and the client firs 3 letters, and then I want to have a extra number in case the date and the client name are the same, to make them different. I tried this but I don’t manage to make the rank different when the client and the date are the same:
thisRow.[Date started].Day(), ToText("-"),
Rank(thisRow.[Date started],[Transactions DB].Filter([Client Name]=thisRow.[Client Name])))
What am I doing wrong?
I really appreciate your help, I’m learning a lot from this community!