if conditions

[jalaomar]

Hi,

can someone help with the following challenge.

I have a table with projects and i would like to display the Total sales price for each projects in a matrix table 

from my datasource which i can't impact i have this Project A having 2 different statuses with sales price for each status 

how can I can replace the Closed status to Open just for that specfic Project A? as seen in below pic, the outcome i am looking for.

keep in mind that i only want to replace the closed status for Project A only.

[ribisht17]

hi @jalaomar 

Can we use Column, then it will be pretty simple

New_Status = IF('Status'[PROJECTID]="A","Open",'Status'[Status])

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[jalaomar · Accepted solution]

Hi,

I actually found another solution that worked in Power Query 

This YouTube tutourial helped a lot but really appriciate your support!

https://www.youtube.com/watch?v=XpZTPEBHQOY

[ribisht17]

This is the same what I did with column 🙂, you can set the relevant answer/answers as correct so that it can help others/you can set your own answer as correct as well

[ribisht17]

@jalaomar 

Replace your status with this one and you will get the answer

Status_New = CALCULATE(max('Status'[Status]),ALLEXCEPT('Status','Status'[PROJECTID]))

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[jalaomar]

Hi,

almost but it didn't work. instead of status TECO, want both rows as REL.

And not impacting the status of other projects. noticed that other projects had their status changed