Showing old existing/latest data until there's a new data uploaded

[jdw_msft]

Hello everyone, i have problem to show any data that appeared on July 22nd and July 30th. How to add a function that can show existing data in date slicer selection (like if on July 23rd until July 29th there's no data uploaded, data from July 22nd still shown). Until new data uploaded, only latest data shown. Is there any DAX that can i implement? like creating ins_true tabe colum with TRUE/ FALSE boolean data type or anything else?

Thanks.

PS: the "issue_progress" is a Text/string data type

Here's the July 22nd data

Here's the July 30th data

Data is blank if it selected July 29th

[jdw_msft]

Thank you for your assistance, it works like a charm

[jdw_msft]

This is good, but the issues_progress is a text/string data type. You can fill with any text content

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

One of ways is to create a measure and put it into the visual level filter pane.

last non blank select: = 
VAR _DateSelect =
    MAX ( 'calendar'[Date] )
VAR _lastnonblankdate =
    LASTNONBLANK (
        FILTER ( ALL ( data[upload_date] ), data[upload_date] <= _DateSelect ),
        MAX ( data[issues_progress] )
    )
RETURN
    INT ( MAX ( data[upload_date] ) = _lastnonblankdate )

[jdw_msft]

Thank you @Jihwan_Kim for the first solution, but what if the data are like this? Assuming if the data is text only

[Jihwan_Kim · Accepted solution]

Hi,

Sorry that I do not fully understand, but please check the below picture and the attached pbix file.