Display latest month based on time frame already selected with a timeline slicer

[Anonymous]

Hi, 

I have created a dashboard to display project metrics based on data pulled from JIRA. Each month, project info is exported, causing duplicates in the data. Sometimes, it is only the status - "Open" - "Paused", "In Progress", etc that changes. I have a table on the dashboard that shows project key, status, assignee, summary, and other info. If a user selects a timeframe (April, May, June) in the timeline slicer, the table displays duplicate project IDs. 

I would like to only show the last updated project id row based on what is selected in that timeline slicer. For example. Project ID-1 was 'Open' in April, 'Ready' in May, and then 'In progress' in June. I would only like to show ProjectID-1 with status 'In Progress' from June in the table. Now it is July, so there is July data already in the backend. I just want to show results based on the timeline slicer, not MAX date or LATESTDATE of all the data. A filter for max date or latest date does not work; the table will return blank since there is July data available already. 

Thanks in advance! 

[amitchandak]

@Anonymous , Can you share sample data and sample output in table format?

[Anonymous]

@amitchandak 

I hope this helps. I have 3 months selected in the timeline but I only want the latest IPACP-201 (June) in the table below. 

[dax · Accepted solution]

Hi @Anonymous , 

You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , add this as one measure or all measures like these

export date = lastnonblankvalue(Table[latest_updated],max(table[export date]))

or

Measure =
VAR __id = MAX ( 'Table'[Key] )
VAR __date = CALCULATE ( MAX( 'Table'[latest_updated] ), ALLSELECTED ( 'Table' ), 'Table'[Key] = __id )
RETURN CALCULATE ( Max ( 'Table'[latest_updated] ), VALUES ( 'Table'[Key ), 'Table'[Key] = __id, 'Table'[latest_updated] = __date )