Displaying Change in Value by user Selected Date Only If there is a change

[omustu]

Hi everyone,

I have been trying to create a report where user's can compare data of two different date's they selected.  I want to compare the row's with the same UID and display them only if there has been a change in the value. 

For the screenshot's above, let's say our user wants to compare the changes that had happened between the dates 02.12.2024 and 05.12.2024 (they might choose another date of course) and choose those dates from the slicer. Then the user should bee seeing the UID's that have had their 'Status' value changed from 02.12.2024 to 05.12.2024. One thing i should mention is, my powerbi data is getting updated daily so the UID's from a later data might not exist inside an earlier data (for example, a UID might be newly created and uploaded in 05.12.2024 hence, it wont exist inside 02.12.2024's data)so i need to look only to the data that exists in both date's. I have tried creating a calculated table and calculated column but those do not dynamically change as the user changes the date's they want to compare. Of course i can just create two date slicer and tables and user can filter them but that won't be immediately giving the user the UID's that have had changed from one date to another, that will also include UID's that have stayed the same and i don't want that. Also, i don't need any calculation or whatsoever, i just need to display what the value was before and what it is now (for the selected dates). 
Feel free to ask further questions if the explanation is not clear. 
I'm stuck so any help is appreciated.
Thank you all for your time.

[Selva-Salimi · Accepted solution]

hi @omustu 

to fulfill your expectation write a measure as follows:

status_change = var min_date = minx( ALLSELECTED('my_table'),'my_table'[Date])

var max_date = maxx( ALLSELECTED('my_table'),'my_table'[Date])

var min_status = CALCULATE(min('my_table'[Status]) , FILTER('my_table' , 'my_table'[Date]=min_date && 'my_table'[UID]=SELECTEDVALUE('my_table'[UID])))

var max_status = CALCULATE(min('my_table'[Status]) , FILTER('my_table' , 'my_table'[Date]=max_date && 'my_table'[UID]=SELECTEDVALUE('my_table'[UID])))

return

if(min_status <> blank() && max_status <> blank() && min_status <> max_status, min_status &  "-->" & max_status)

then create a table visual and add UID and this measure 

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

[omustu]

Hi @Selva-Salimi Thank you very much for the quick response. That is exactly what i have been trying to do for more than 5 days, can't thank you enough honestly. I am providing a screenshot here in case someone wants to see how the result looks like.

[Selva-Salimi]

@omustu 

I'm just glad I could help, please mark it as the solution to help other members find it more quickly.