Forum Discussion
Helper IVif conditions
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.
Hi,
I actually found another solution that worked in Power Query
This YouTube tutourial helped a lot but really appriciate your support!
5 Replies
- ribisht17
Super User
Replace your status with this one and you will get the answer
Status_New = CALCULATE(max('Status'[Status]),ALLEXCEPT('Status','Status'[PROJECTID]))Thanks,RiteshMark 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
jalaomarHi,
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
- ribisht17
hi jalaomar
Can we use Column, then it will be pretty simple
New_Status = IF('Status'[PROJECTID]="A","Open",'Status'[Status])Thanks,RiteshMark 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,
I actually found another solution that worked in Power Query
This YouTube tutourial helped a lot but really appriciate your support!
- 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
