topic Re: Showing old existing/latest data until there's a new data uploaded in DAX Commands and Tips

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

jdw_msft — Mon, 12 Aug 2024 04:24:07 GMT

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

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

Jihwan_Kim — Mon, 12 Aug 2024 03:51:30 GMT

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 )

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

jdw_msft — Mon, 12 Aug 2024 04:13:14 GMT

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

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

jdw_msft — Mon, 12 Aug 2024 05:11:07 GMT

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

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

Jihwan_Kim — Mon, 12 Aug 2024 05:23:48 GMT

Hi,

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

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

jdw_msft — Mon, 12 Aug 2024 06:16:31 GMT

Thank you for your assistance, it works like a charm