topic Parent/Child Table Filtering in DAX Commands and Tips

Parent/Child Table Filtering

mikeoshields — Tue, 27 Aug 2019 16:05:00 GMT

I'm sure this answer is already in here but I haven't found it yet. I have two tables in a parent/child relationship. When I pull a single record from the parent, I want to also get all of the fields in the row from the child that is related by ID and where the timestamp = max(timestamp). Any help would be appreciated.

Re: Parent/Child Table Filtering

sturlaws — Wed, 28 Aug 2019 13:20:36 GMT

Hi mikeoshields ,

you can add a isMaxTimestampFlg-column on the many-side of you relationship, i.e. 1 for the rows where timestamp=max(timestamp), and 0 elsewhere. Then you would just have to add this column to the filter section of a visual and filter for isMaxTimestampFlg=1.