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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Find if a text change between different rows

HI Power BI Expert,

 

I'm trying to solve a DAX problerm in Power BI with the following Data:

 

IDSTATUS CODE
100002206
100002205
100002212
100002212
100012855

 

I have a table with two field, "ID" and "STATUS", I would like to find a way to create a calculated column that find if an ID change the Status Code (e.g the Status code in red). I don't mind if the status code is the same, I want to highlight just the different code for the same ID.

 

Any suggestions?

 

Best

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@Anonymous 

is this what you want?

Column = 
VAR _a=maxx(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])&&'Table'[STATUS CODE]<>EARLIER('Table'[STATUS CODE])),'Table'[ID])
return if(ISBLANK(_a),blank(),"changed")

1.PNG

if the ID column is text, try this

Column = 
VAR _a=maxx(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])&&'Table'[STATUS CODE]<>EARLIER('Table'[STATUS CODE])),'Table'[ID])
return if(_a=""),blank(),"changed")




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Thank you very much, it works!

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ryan_mayu
Super User
Super User

@Anonymous 

is this what you want?

Column = 
VAR _a=maxx(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])&&'Table'[STATUS CODE]<>EARLIER('Table'[STATUS CODE])),'Table'[ID])
return if(ISBLANK(_a),blank(),"changed")

1.PNG

if the ID column is text, try this

Column = 
VAR _a=maxx(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])&&'Table'[STATUS CODE]<>EARLIER('Table'[STATUS CODE])),'Table'[ID])
return if(_a=""),blank(),"changed")




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.