Check if an ID has been updated and highlight the cell which was updated

[mdbuzzer]

I'm not quite sure whether this is possible in DAX/Power Bi, but basically I have a table  which looks like the below:

ID     Name               Description         CreatedAt      UpdatedAt

1       Middlesex        Satisfactory         17/05/21       17/05/21

1       Middlesex        Good                   17/05/21      19/05/21

2       Lancashire        Excellent             17/05/21       17/05/21

3       Roehampton    Good                  17/05/21       17/05/21

4       Brunel               Poor                   17/05/21       17/05/21

So I want to check for duplicate ID's because it means it has been updated since the created date, so for ID 1 it should highlight the cell/s which has been updated since the created date which is  "Good" because that cell has been amended.

Is this possible to do in Power Bi?

[mdbuzzer]

Essentially I just want to know if there's a way to conditional format if there is a duplicate ID and then comapare the cells and highlight the cell/s which has been changed/altered

[Jihwan_Kim · Accepted solution]

Hi, @mdbuzzer 

Thanks for the feedback.

please check the below.

https://www.dropbox.com/s/0565wmn7odcrjqv/mdbuzzer.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[mdbuzzer]

I think this solution is just checking whether the description has changed, is there a way to compare the two rows and then highlight whatever cell has changed, because it might not be just description which has been updated 

[Jihwan_Kim]

Hi, 

Sorry, I do not understand your question.

Please share how you want to see the outcome.

[mdbuzzer]

So basically there can be more columns like such and the cells which have been updated should be highlighted:

ID     Name               Description          id2               CreatedAt      UpdatedAt

1       Middlesex        Satisfactory          A1                 17/05/21       17/05/21

1       Middlesex        Good                    A2                 17/05/21      19/05/21

2       Lancashire        Excellent              A3                 17/05/21       17/05/21

3       Roehampton    Good                   A4                 17/05/21       17/05/21

4       Brunel               Poor                    A5                 17/05/21       17/05/21

So there will be numerous columns but in this example it should highlight the cell "Good" and "A2" because they were both changed since the last time that ID was created. Is there a way to basically check every single column or does a measure need to be created for each column to check whether it has been updated?

[Jihwan_Kim]

Hi,

I still do not know how your whole data model looks like, but in this case, only one measure that defines the condition is needed, like what I have created in the previous sample. However, each column has to be set. For instance, if you want to set up five columns, then five times settings have to be made by using one measure.

[mdbuzzer]

Is there a way you can explain it using the DAX you created previously, to amend that DAX to check 2 columns so the description column and id2 to see if they have been changed. I'm not sure how to check 2 columns at the same time

[Jihwan_Kim]

Hi, 

Sorry I still cannot understand. As I mentioned, in this case, you need two times settings in order to check two columns. If you want to check five columns in your real data model, I think you need five times of settings.

Please check the below link.

https://www.dropbox.com/s/tg7shb4lzkfi6n4/Presentation2.mp4?dl=0 

https://www.dropbox.com/s/0565wmn7odcrjqv/mdbuzzer.pbix?dl=0 

[Jihwan_Kim]

Hi, @mdbuzzer 

Please check the below picture and the sample pbix file's link down below.

It is for creating a new measure.

Most Updated Description =

VAR lastupdated =

CALCULATE ( MAX ( 'Table'[UpdatedAt] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) )

RETURN

IF (

MAX ( 'Table'[UpdatedAt] ) = lastupdated,

SELECTEDVALUE ( 'Table'[Description] ),

""

)

https://www.dropbox.com/s/0565wmn7odcrjqv/mdbuzzer.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM