Forum Discussion
Selecting active records from a table
I have a table of data that contains one or more records for a particular item. Only one record is the current active record and this has to be determined based on the values in several date fields...
Thanks. That helps. I haven't used Power Query and Power BI enough yet to get my head out of the Access "write a query with multiple criteria" mentality.
Hi RobDueck ,
I think "Filter Rows" may be fine to grouped in one query, but ranking in category is tricky in Power Query so we take more steps to get it.
Does this solve your question?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Thanks!