Forum Discussion
How to filter a visual to only show the latest rows based on dataLake_CreatedTime
Body: I’m working with a snapshot table in Power BI that refreshes frequently. The table has multiple rows for the same record ID, each with a different dataLake_CreatedTime (datetime) showing when ...
Hi Greg_Deckler , thanks for the proposal, but that’s not quite what I’m looking for. I need my card visualization to show only the most recently updated data—specifically, the latest JobReq_JobReqId based on the DataLake_createdtime field. I’ve attached a screenshot for context.
- Greg_Deckler
Community Champion
kendomino So that's what I call a double lookup. It looks something like the following:
Measure = VAR __Table = ALLSELECTED( 'Table' ) VAR __MaxDate = MAXX( __Table, [DataLake_createdtime] ) VAR __Result = MAXX( FILTER( __Table, [DataLake_createdtime] = __MaxDate ), [JobReq_JobReqId ) RETURN __Result
