Forum Discussion
Using RankX and AddColumn to a Virtual Table
I am trying to create a formula that will first rank the data based on the [Date-Calendar] column grouped by the Claim Num (Full), then count the rows where the Rank = 1. Here is my formula: ...
Hi Anonymous
I'm not sure I follow. How is this:
first rank the data based on the [Date-Calendar] column grouped by the Claim Num (Full), then count the rows where the Rank = 1
different from simply doing a DISTINCTCOUNT of Claim Num Full, i.e. the number of groups??
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers