Condition based formatting

[Anonymous]

Hi,

I have this data and want to change the Decline status of them:

So prevoiusly Mother cases could have 4 different status and now they only have 3. Daughter had 6 different and now it is also down to thrree. I cant just replace value as "Not applicable as GP", in the case of daughter translates to something different than in the case the type is mother.

Any help how I can do this would be much appreciated. I would prefer to do the changes in query.

Also, this data is updated continously but all new informaiton will be correct to the 3 new decline statuses. So if I could just change the existing values in the column and ignore any new that would be great.

Regards
M

[PattemManohar]

@Anonymous  You can try using the Lookup Table where you have CascadeType and Decline Status (New) and DeclineStatus (Old). Use this lookup table in your calculated column using LOOKUPVALUE function to dervie the new DeclineStatus, when there is no match found then you can add another condition for Mother and Daughter in the logic. Doing this way will simplify and it is future proof as well !

Note - If you can post the sample data in text format then it will be useful to copy and paste than the image format.

[Anonymous]

@PattemManohar sorry, I am quite new to Power BI and not sure how to do this. Do you mean that I should create a new table with the correct "translation" and then add a calculated column in the table with all data from database? So I cant go in and change in the existing column then?

Here is the table again

What I have		What I want
Cascade type	Decline status (old)	Decline status (new)
Mother	Not applicable	Not applicable as GP
Mother	Not applicable as GP	Not applicable as GP
Mother	Weak of quality in GP	Poor quality of GP
Mother	Already implemented	Similar already implemented
Mother	Not applicable	Not applicable as GP
Daughter	Not applicable as GP	Not applicable to the factory
Daughter	Weak of quality in GP	Poor quality of GP
Daughter	Weak of quality in GP	Poor quality of GP
Daughter	No loss exist	Not applicable to the factory
Daughter	No resources	Not applicable to the factory
Daughter	Similar Implemented	Similar already implemented
Daughter	Similar Implemented	Similar already implemented
Daughter	Not applicable	Not applicable to the factory
Daughter	No loss exist	Not applicable to the factory
Daughter	No resources	Not applicable to the factory
Daughter	No resources	Not applicable to the factory
Daughter	Not applicable as GP	Not applicable to the factory
Daughter	Not applicable as GP	Not applicable to the factory

Regards

M