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
jalaomar
Helper IV
Helper IV

if 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.

 

2022-08-12_11-13-51.png

1 ACCEPTED SOLUTION

Hi,

 

I actually found another solution that worked in Power Query 

 

jalaomar_0-1660299879832.png

 

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

 

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

View solution in original post

5 REPLIES 5
ribisht17
Super User
Super User

hi @jalaomar 

 

Can we use Column, then it will be pretty simple

 

ribisht17_0-1660299607328.png

 

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 

 

Hi,

 

I actually found another solution that worked in Power Query 

 

jalaomar_0-1660299879832.png

 

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

 

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

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
Super User
Super User

@jalaomar 

 

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

 

Status_New = CALCULATE(max('Status'[Status]),ALLEXCEPT('Status','Status'[PROJECTID]))
 
ribisht17_0-1660296381044.png

 

 
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 

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

 

2022-08-12_11-35-15.png

 

2022-08-12_11-38-19.png

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.