Forum Discussion
Single Date Selection
I have many customer transactions: Trans Date/Time Customer Currency 1 Jan 10 2019 11:35 MyCust B I also have a currency his...
Your solution looks like an elegant one. I may have oversimplified the situation however. Please see the table I need to arrange:
And it needs to end up looking something like this:
What I have realised I can go it create a GroupID field based on concatenating the CompanyID and the Currency. This would simplify my setup.
This gives me a single column identifying the company/currency combination for each record. I have tried to rank this using:
Rnk = RANKX(FILTER(CurrencyHistory,CurrencyHistory[GroupID]=EARLIER(CurrencyHistory[GroupID])),CurrencyHistory[chDateChanged],,ASC)
I get a message however saying "EARLIER/EARLIEST refers to an earlier row context which doesn't exist."