Forum Discussion
Latest Record in Group via Query Editor
We are trying to get the latest record/row in a group via Query Editor. After we expand the group and we filter on the latest record, it filters the entire dataset and not within the group. Please ...
Hi Marcel,
Thanks for your help and we believe we are close. The logic behind your code makes sense for what we are trying to accomplish; however, we are getting the following error trying to preview/expand the subtable of the grouped rows.
Expression.Error: The field 'SettleID-Statement_Group.statementDate' of the record wasn't found.
Any idea?
Also, should we be trying to select/filter on grouped rows at the query level (Query Editor) OR it is better to create a calculated table instead? If so, any suggestions on the DAX for the calculated table?