Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
mdbuzzer
Helper I
Helper I

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

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?

1 ACCEPTED SOLUTION

Hi, @mdbuzzer 

Thanks for the feedback.

please check the below.

 

Picture6.png

 

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

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


Go to My LinkedIn Page


View solution in original post

9 REPLIES 9
mdbuzzer
Helper I
Helper I

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

Hi, @mdbuzzer 

Thanks for the feedback.

please check the below.

 

Picture6.png

 

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

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


Go to My LinkedIn Page


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 

Hi, 

Sorry, I do not understand your question.

Please share how you want to see the outcome.

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


Go to My LinkedIn Page


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?

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.

 

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


Go to My LinkedIn Page


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

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 

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


Go to My LinkedIn Page


Jihwan_Kim
Super User
Super User

Hi, @mdbuzzer 

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

It is for creating a new measure.

 

Picture3.png

 
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

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


Go to My LinkedIn Page


Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.