Forum Discussion
ryan_b_fiting
Post Patron
Post PatronFinding the 'Current' Status based on most
Hello Community - We want to report for the last day of each historical month how many people were in each state. If that data looked like this (for a single learner): LearnerId Status ...
v-easonf-msft
Community Support
Community SupportHi ， ryan_b_fiting
I made a sample file, it can meet your requirements.
The result will show as below:
For more details ,please refer to the sample file
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.